Linked Text Fields

[sam.schlesser]

Hey ,

Our company is changing vom MS producs to open source stuff und at the moment i have to do
a database for our housekeeping section but i have a problem.

I have watched and read lots of manuals and tutorials about base but i cant find it.

My problem:

I have 3 tables.
1 - tblhousekeeper. incluedes the first and last name of the housekeeper.
2 - tblclient. includes all the informations about the client.
3 - tblaction - here it comes all together. and here is my problem.

I made it to load one field from tblhousekeeper into the form and saves it into the table tblaction. So far so good.

What i need now is that all the informations about the client are loaded into the form when i select his last name per dropdown menu.

I choose "Smith" and whoop. There is his full adress and phone number out of the tblclient in the form.


Sorry for my bad english and greetings from Luxembourg.
Sam

[Villeroy]

Each client has exactly one house keeper? That would be a called a one-to-many relation (1:n).

[sam.schlesser]

No ,

Lets forger my first post . I try to explain it more simple.

Lets say i have 2 tables and 1 form.

In the first table are all the informations. Also the same as in the table 2. In the second are all informations about the customer saved.

The form shows table 1 but allowes to select old custumers by a dropdown field of the last name.

I hope this is bether to undertand. If not i try it again and again

[Villeroy]

We are talking about a relational database, right? The status bar of your main database window shows something with "HSQLDB", right?
Again, is it a one-to-many relation where one house keeper from the table of house keepers belongs to each client in the table of clients?
DO the tables have a running number, a unique ID column for each record?

[sam.schlesser]

Forget the housekeepers .

I want a dropdown wich says to other fields: "You load that , you load that"


To answer the question with the ID here the second screenshot.



When i want to do relations i says me that i have no primary key but i do. You can see it in the screenshot to.

[Villeroy]

Sorry, I had to leave yesterday and then the forum was down for quite a few hours. You are trying to create forms on top of a insufficiently designed database.
OK, add a combo box, bind it to the field in question and set it's source to something like:

Code: Select all

SELECT DISTINCT "Name" FROM "SomeTable" ORDER BY "Name"

This will load all unique values from column "Name" of a table named "SomeTable" into the combo box. The combo box will suggest the values and write the chosen value to the bound field in question.
This will not prevent writing any other value into the table since your database does not use referential integrity through relations.