D
DavidHoward
Guest
Hi,
An easy one I'm sure
Two tables - "Advertisments" and "ApplicationSource".
"Advertisements" holds the details of adverts placed against job references. ApplicationSource holds respondant info.
When completing the relevant field in "ApplicationSource", I wish only those records that match a criteria (ie JobRef) to be displayed in the drop-down box.
Advertisements:
Job Ref
Publication
Cost
ApplicationSource:
Job Ref
Source
(Set up like this to avoid many-many relationship)
Any help would be gratefully appreciated.
David Howard
An easy one I'm sure
Two tables - "Advertisments" and "ApplicationSource".
"Advertisements" holds the details of adverts placed against job references. ApplicationSource holds respondant info.
When completing the relevant field in "ApplicationSource", I wish only those records that match a criteria (ie JobRef) to be displayed in the drop-down box.
Advertisements:
Job Ref
Publication
Cost
ApplicationSource:
Job Ref
Source
(Set up like this to avoid many-many relationship)
Any help would be gratefully appreciated.
David Howard