D
debb66
I want to build a simple database….
All tables will be linked to a Commercial Manager
There will be three tables
Commercial Manager containing:
CommercialManager ID (Auto-number) Primary Key
Commercial Manager Name
Project Table containing:
ProjectNameID (Auto-number) Primary Key
CommercialManager ID
ProjectName
Region
Project Detail Table containing:
ProjectDetailID (Auto-number) Primary Key
CommercialManager ID
Scope
Price
Cost
Date Approved
Approved By
My issue – I link all the tables together but I want everything to be linked
to the commercial managers name so when I create my form it will pull up only
those Projects and Details that are related to the Commercial Manager Name.
I can’t get this to work and I’m sure it is a simple event I’m missing.
Thanks to anyone that can help!
All tables will be linked to a Commercial Manager
There will be three tables
Commercial Manager containing:
CommercialManager ID (Auto-number) Primary Key
Commercial Manager Name
Project Table containing:
ProjectNameID (Auto-number) Primary Key
CommercialManager ID
ProjectName
Region
Project Detail Table containing:
ProjectDetailID (Auto-number) Primary Key
CommercialManager ID
Scope
Price
Cost
Date Approved
Approved By
My issue – I link all the tables together but I want everything to be linked
to the commercial managers name so when I create my form it will pull up only
those Projects and Details that are related to the Commercial Manager Name.
I can’t get this to work and I’m sure it is a simple event I’m missing.
Thanks to anyone that can help!