T
TheScullster
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
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