help please

[olivercastell]

hello,

I Have one database of pharmaceutical products with required warning labels and a second database of products supplied. Is there a way I can create a form for entry of data into supplied database with a listbox for products so that when I choose a product the appropriate warning label requirements are entered into the supply database automatically??
I understand I cant do this from a querry except for setting the criteria to be manually typed in (ie no listbox)

Many thanks

 

[olivercastell]

It is not necessary, nor is it appropriate to duplicate the warning label requirements. Whenever you need to include data from this table, simply use a query that joins to it. That way, if the warnings change next week, you won't need to update the "duplicates" in your table. If you don't understand why storing data multiple times can cause update anomolies, do some reading on database normalization. There are many posts here and in the Microsoft kb and MSDN library.

OK thanks
will have a look

cheers