hi,
Our company has a (parts record) database this database has about 50 tables in it
for example , say table 111,222,333,444 etc
each table will have parts in it with referencing I it say there are 5 parts in table 111 the parts could be
111-001
111-002
111-003
and table 222 would have parts in it called
222-001
222-002 etc etc
the engineering department want to keep this database
I have another access database that needs to access the part numbers and select them from a drop down box but I need to see them all at the same time.
how can I get all the tables into one table then link that database (parts record) to my database to select the parts i need from the drop down box
the data base that has all the table in it must always be upto date with the table that will have all the records in it
thanks steve
Our company has a (parts record) database this database has about 50 tables in it
for example , say table 111,222,333,444 etc
each table will have parts in it with referencing I it say there are 5 parts in table 111 the parts could be
111-001
111-002
111-003
and table 222 would have parts in it called
222-001
222-002 etc etc
the engineering department want to keep this database
I have another access database that needs to access the part numbers and select them from a drop down box but I need to see them all at the same time.
how can I get all the tables into one table then link that database (parts record) to my database to select the parts i need from the drop down box
the data base that has all the table in it must always be upto date with the table that will have all the records in it
thanks steve