setting up tables
- Thread starter btappan
- Start date
Thanks Bob, I made the changes to the names and data type fields and also checked "enforce referential integrity" as you had in your sample db. what feature do i need to use to export the data to a flat like view that i need it in on occasion for viewing? also, If i made flat sheets of part # and their spec, can they be easily imported to this format i am now trying to work with and with what method? thanks
boblarson
Smeghead
- Local time
- Today, 13:49
- Joined
- Jan 12, 2001
- Messages
- 32,059
If EVERY part will have a manufacturer, you can include it in Table 1.
As for exporting data, you would just create a query that pulls all of the fields together, but you would set it to use a left outer join from the parts table (table one) in order to get all info from table 1 and all data that matches in Table 2 and table 3.
As for exporting data, you would just create a query that pulls all of the fields together, but you would set it to use a left outer join from the parts table (table one) in order to get all info from table 1 and all data that matches in Table 2 and table 3.
