gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
Were i work there is database that has several tables. But pretty much everything is based on one main table in that database. Most of the other tables are for Combo/listboxes sources data in the main table named QUOTES MASTER FILE.
The Owner will not allow anyone to touch the data, especially the QUOTES MASTER FILE table. This database was built years ago and by someone with very basic access development experience. The databases main purpose is to track information about Quotes. So the QUOTES MASTER FILE has a field called/titled “Quote Number”. There is a bunch of other fields in the table but that are all fields that have information about the “Quote Number”. New Quote Numbers, and information about the quote are entered into the data base daily.
My problem is I need to also track data about quotes. But I cannot add new fields to QUOTES MASTER FILE table.
How do I create a new table that will have the same list of Quote Numbers – even new ones when they are added?
Thanks
The Owner will not allow anyone to touch the data, especially the QUOTES MASTER FILE table. This database was built years ago and by someone with very basic access development experience. The databases main purpose is to track information about Quotes. So the QUOTES MASTER FILE has a field called/titled “Quote Number”. There is a bunch of other fields in the table but that are all fields that have information about the “Quote Number”. New Quote Numbers, and information about the quote are entered into the data base daily.
My problem is I need to also track data about quotes. But I cannot add new fields to QUOTES MASTER FILE table.
How do I create a new table that will have the same list of Quote Numbers – even new ones when they are added?
Thanks