View Full Version : Really Fustraitng me can you help?


AWilderbeast
09-26-2005, 05:30 AM
Hi,
I have a database with table 'Businesses' and 'Vacancies' what do i do to match a vacancy to a business, I have tried many ways and tried to understand it all.

Im a bit of a noob at access and would really appreciate any help you can give me

Thanks

neileg
09-26-2005, 08:29 AM
Bit short of information, here!

Do you mean that you want to identify which business the vaccancy relates to? If so, you should have a field in the Business table that uniquely identifies the Business record. This should be a key field. In the Vaccancy table, you need a field that you populate with the key field of the Business.

See the sample form