Having Problems With Relationships...

[Choby]

Okay, I am making a database with drink tables and a supplier table.

Here is the setup I have, each catagorie of drink has it's own table.

Though, once I have enterd the data, whenever I click the little cross sgn [+] to view the relationship, this keeps poppin up:

Could anybody tell me what I am doin wrong or suggest an alternitive way?

Many thanks in advance.

 

[boblarson]

First of all, you need to look into normalization. You don't want tables with repeating fields. It will only cause you pain and suffering later when you try to get information out. (check out posts by Pat Hartman - she knows what she's talking about).

I am enclosing a suggested different way of doing it from the way you currently have it. While I didn't spend a whole lot of time on it, so there are many changes that probably need to be done in order to get it to what you need (and realize some of it is personal preference as opposed to "you must do") so play with it.

The second thing is that you should add/edit data within FORMS instead of in the tables directly.

 

[theprez]

Listen to Bob. Before I could even get to your + problem, I could not get around your normalization problem. You only need one Drink table with a field, preferable a drop down list box or combo box that list the type of drink, Vodka, Rum, etc..

I don't thing the issue with the Plus is an error, but Access atempting to put a sub table under it.