Cannot enter data with form - help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
 
Back
Top