If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with Database Setup
Hi all
Following the "Linked Tables Twice" thread, I would appreciate some input into construction of a database. An existing database manages the control and delivery of drawings in our design office and I would like to add a feature (Access2000 existing back-end with Access2003 front-end). Rather than make changes to the original application, the intention is to link to the existing back-end with a new task-specific front-end and write data into tables in a new separate back-end. In the existing back-end there are two of the exisiting tables which contain relevant information. tbAccount ac-id Autonumber PK ac-title text project description ca-id number customer identification (foreign key from tbCustomerAddress) ct-code text contract number pp-code text enquiry number ----- ----- tbCustomerAddress ca-id Autonumber PK ca-code text Customer description The new back-end will simply contain the link between contracts in a table with a comments record. In the process of our business, we may well carry out repeat contracts for the same customer on different sites. Or equipment originally supplied for one contract may be used to fulfill another. So the purpose of this new application will be to select 2 different contracts (ac-id PK) and create a table for text entry to describe the connection between them. Can someone please start me off on this? Something like - create query to show.. - create form based on query to do... etc. It's a while since I was involved in Access, so a shove in the right direction would be appreciated Thanks in anticipation Phil |
Thread Tools | |
Display Modes | |
|
|