Linking Tables for combo boxes

  • Thread starter misschanda via AccessMonster.com
  • Start date
M

misschanda via AccessMonster.com

Hello,
I have made some cascading combo boxes (were make final selection based off
choices of combo box previous). Well boss wants to change some things around
and I need some help.

I have a table with all raw materials this table has supplier date receieved
etc concerning that raw material. For the combo boxes I copy 3 main fields:
category, description and material and gave each of these fields there own
table. In each of the new tables I also included fields that linked the
table together so it would better me in my cascading option.

well, new raw materials have come in and have been inserted into the grand
table that host all raw material and other information like supplier and
receive date. My problem is getting that information to show on the 3 new
tables, so that new materials can be seen in the choice of the cascading
boxes. How is this done.

Thx
LA
 
G

Guest

You can use a query as the row source for a combo. This is actually
preferrable to having a separate table for each.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top