Cannot enter data with form - help!

[Guest]

Hi,
I am having problems with a (fairly) simple database.
The purpose is to maintain a list of events at our Yacht Club, and faclities
associated with each event, and the

details of the organisers of the events run at the club.
There are 2 main tables, and a small addtional one that may not be essential.

Fixtures tbl
EventID PK
EventName
Startdate
Location
etc.
ContactID FK links to Organiser tbl (relationship shown as 1 to many Contact
to fixtures )

Contacts tbl
ContactID PK
FirstName
LastName
Phone
etc

Locations tbl
LocID PK
Location linked to Location in the fixtures tbl
Price 1
Price 2 etc

My problem is that a form I am trying to design to add new events to the
database with fields from each table does not work.
I can enter data in the contact fields, but when I try to put data in the
fields from the fixtures table I get an error beep!
I have tried adding the EventID feld to the contacts tbl and using that as a
link but that made no difference.

I have obviously made some very elementary error in setting this up, and
would appreciate pointing in the right direction.

 

[Guest]

Your first mistake is using the word "simple" in the same sentence with the
word "database."

I would suggest some slight changes to your tables.

tbl_Events
EventID (PK)
LocationID
ContactID
EventInfo

tbl_Locations
LocationID (PK)
LocationInfo

tbl_Contacts
ContactID (PK)
ContactInfo

Create relationships between the foreign keys in tbl_Events and the primary
keys in tbl_Contacts and tbl_Locations. This assumes that you have one
location and one contact for each event. A query and form based on these
tables should work.

 

[Guest]

Many thanks,
I have now got it working, used a query with all the fields from both
tables, and used that as the source for the forms I wanted.
Most grateful
Leigh