I am still trying to build a Database which needs to be a Return Goods Form. My original form has 10 fields each for,
Quantity, Part Number and Description, using my company's paper Return Goods Memo as a template. It also has fields for Date, Invoice Number, Type of Return (Part, Core or Warranty) and Other Information. This form will always have 1 Record as a minimum, but could have as many as 10, or more in some cases. I have been corrected by Richard for having built it this way, but in my mind, 1 paper Return Goods Form equals 1 Record in Access, reguardless of how many items are on the paper form. This current form is a single form format.
I have also built a Continous Form format but using Single Line Items for All entries mentioned above. I know doing it this way makes it easier to search the table if you need to, but it seems to me that using this method is adding a lot more entries for what should only be a single record of returned item or items. There has to be a better way to do this. I DO NOT NEED ANY kind of pricing or putting back into inventory quantities. All I am trying to do is to NOT have to search through 100's of paper Return Goods Memos that come in each month, to find if one specific memo has actually been returned or not. Hence the question, How Would Richard Do It?
Thank you,
David