Problem with related fields...
I have two related fields, the parent is "Locations", the child is "Personel". I have a primary key in Locations that adds an increment with each record and is non-modifiable. I have a foreign key in "Personel" that is plain text and is modifiable. Both of these tables are related and do not allow for creation of records with each other.
The location table is full of addresses, building names, phone numbers and faxes. I want to be able to select the primary key from the Personel table and have that liked together. The only way I can get it to work is if I allow for modification of the Locations primary key, or allow creation of records. When I allow for this it just starts creating more records on the Locations side, which is not what I want. I don't want to modify or create any records from this side, only select them. Any ideas?