I have the following issue.
Advertisements Database
Adv_ID
Advertisement
used to track All of our Ad sources: Newspaper, Radio, Facebook ...
Customer Database
CustomerID
Demographic data...
used to track our customers
Adv_DateID Primary Key
Adv_ID Foreign Key to Advertisements
Adv_Date
To Store the date of that type of Advertisement Since the advertisements could be published multiple times
Finally a linking Table to put all of the data together
CustomerID
Adv_ID
ADV_DateID
the linking table is used as the source for a subform. The main form is the customer and the 2 forms are linked by the customerid. The subform has 2 combo boxes one that uses the Adv_id to pull the Advertisement that produced the call by the customer and one that uses the Adv_DateID to pull when that advertisement was run.
The problem is that the data for the Adv_Date combo box is dependent on the data for the Advertisement combo box and I can't seem to get it to work.
the SQL for the second combo box uses the first combo box as the criteria. "Select Adv_Date from tbl_Adv_dates where Adv_DateID = Combo0"
I've tried putting brackets around the Combo0 tried the full path Forms!frm_Adv_date!combo0 Tried me.combo0 Nothing works. Any help is appreciated.
A linking table to associate the customer with the advertisement that produced the call
CustomerID Foreign Key
Adv_ID Foreign Key
AdvDate Date the Ad Ran
There is also a table to track the Advertisement Date since 1 Advertisement type Newspaper etc could be used multiple times and multiple customers could call in on them
Adv_ID
Customer_ID