currently, i have a form where a user can manipulate data. however, because i only want them to change "Supplier" of a product to a known one, i have created a second form. which they click (next to the supplier entry field.) this displays a list box ( with supplier id as an index). i have got it so that when someone lciks on an entry in the list box, the supplier is changed. however, my way of doing it seems ineeficient. here is the basics:
form1 : finds data relating to a product, searches the supplier table for the supplier name to display
open form 2>click supplier> click ok
form1 gets id from form2 and searches supplier table for name> displays name
is there a more efficent way of coding this?
i have 2 ideas for storing invoices
1) invoice# = primary key, all products listed in a text box, csv
2)primary key= auto number. single database entry made for every product sold (invoice# also repeated)
which one of these would be the best to use?
or are there better ways?