Relate more than one table to a single registration screen

Question

Relate more than one table to a single registration screen

Navigation

#1 by (1 votes)

1

I have a resume screen as shown below.

What I needed to do is just register, but the problem is that I have three records on this screen, that of personal information, phones and emails.

The phone and email are linked as foreign keys in the personal information. (I did this so he could register the number of phones and emails he wants).

My question is this: when I have more than one registration, it will mix with other phones.

For example:

A person registered, so I go and register several phones and emails of this person. When I sign up for the second person, the phones and emails will still be showing, I would like it when I ask to register a new one, the two dbGrid were cleaned and went to the other person.

delphi dbgrid

asked by anonymous 01.04.2015 / 17:52

1 answer

Shoot event (F11)? Open iframe links

score 1 · Accepted Answer

You did not specify the data access technology you are using, but you, as I understand it, need to establish a relationship between the table of resumes and the telephone table and email a very popular way of doing this would be to use master-detail relationships.

In Delphi you can do this by configuring the data access components. In your% of the detail table (phone or email) you must indicate in the DataSet property the name of MasterSource of the master table (resumes). It is also necessary to inform the property DataSource of this MasterFields of the key fields that will be used to relate the two tables.