Problem with tables

[markymark71]

Hi, Not sure if this is the best way to post I am a newbie!!
I am trying to build a database for my entertainments agency.
The problem I've been having is getting the table to pull information from each other. I have tried several ways and created tables and tried using a form..but the form as none of it. I have created the following tables...

tbl_Agency AgencyID (PKey), AgencyName, AgencyAdd1, AgencyAdd2, AgencyTown, AgencyPostcode

tbl_Acts ActID (PKey), ActName, ActAdd1, ActAdd2, ActTown, ActPostcode, ActAgency, AgencyID(FK)

tbl_Venues VenueID (PKey), VenueName, VenueAdd1, VenueAdd2, VenueTown, VenuePostcode, VenueAgency, AgencyID(FK)

I created a form for each....Filled out two records on the Agents form. On the Acts form I changed ActAgency to a combobox and directed the row source to AgencyName field in tbl_Agency..although it allows me to use the combobox in the Acts form, it does not allow me to add fields from the Agency table to the Acts form.
Any help much appreciated.

Mark

 

[jdraw]

work through this tutorial

You haven't mentioned relationships nor foreign keys