Really Fustraitng me can you help?

[AWilderbeast]

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]

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