Problemer med relationer

Cant see your form but at a guess you need a realtionship between

Persontable and arbejde
and also
Persontable and private

what do the tables "arbejde" and "privat" contain? If a record is specific for a person then you MUST have a field in these tables which realtes to the person table.

Hej Terry
Jeg har allerede relationer fra persontabellen (id, fornavn, efternavn) til tabellerne Arbejde (id, adresse, tlf., mail) og Privat (id, adresse, tlf., mail). Arbejde-tabellen relatere endvidere til en postnr. tabel. Det samme gør Privat-tabellen. Det er dog ikke samme postnr.-tabel der relateres til, da jeg ikke kunne få det til at virke

I can take a look if you can send it to NOSPAMeksperten@santhell.dkNOSPAM

remove NOSPAM

Hej Terry. Tak. Jeg sender den til dig.

Hi Janne, I have received your dB and will take a look now. Its normally a good idea to wait in giving points until you get an answer you can us. I may notbe able to find a solution, or someone could give one before me :o)

Undskyld, men det er første gang jeg bruger eksperten.dk.

Yes I see :o) and welcome

OK, I've had a look at your database.

Your relationships are totally wrong! The primary key in Person table is an autonumber, this is OK. The primary key in PrivatAdresser is also an autonumber. This again is OK, BUT!!!!! you are using the primary key in this table as the relationship to the person table, whcihjsut WILL NOT work.

Make a new field in PrivatAdresser, when you choose the data type for this field you will see one named "lookup wizard" or something like that. Choose the type for the new field and follow the instructions. This will create a "foreign key" to the person table.
Take a look at the realtionship from the PrivatAdresser table to postnr-privat, this is how it should be.

The same problem applies for Arbejdsadresser, again you are using the autonumber (primary key) as the foreign key to person!

When you have done this you need to make a form for Arbejdsadresser and one for Privatadresser. Then drag and drop these two forms onto the form for person. This will give you two sub forms on the person form.

Sounds like a lot of work, but I'm sorry to say it is necessary or you will not got it working!


but if you only want ONE private address and ONE work address then the fields in these two tables should be in person!

whcihjsut WILL NOT work. = which WILL NOT work.

If you need further help then send me a mail and I will get back to you.

It is important that the table design is correct BEFORE you make your forms!

tak Terry. Det vil jeg prøve. Ja, det lyder som en del arbejde, men hvis det løser problemet gør det ikke noget.