 Values in different tables [message #327510] |
Mon, 16 June 2008 11:52  |
Akkuch
Messages: 1
Registered: June 2008
|
Junior Member |
|
|
Hi. 
There are this tables in my database:
(-lists-)
(-clients-) [id]
[id]-----------[client_id] (-events-)
[name] [event_id]------[id]
[type]
[date_event]
It's necessary to create the data block from the table 'lists', which contains this text items:
[lists.client_id NUMBER]
[lists.event_id NUMBER]
[clients.name CHAR]
On change field client_id (by request or manually or otherwise) the field clients.name must change too, getting information from 'clients'. Similarly on change field clients.name the lists.client_id must change too.
For example, there is the client named "1 Smith", the event "Party 15.06.2008". Typing '1' in the field client_id, in name must appear 'Smith' and vice versa.
Thanks, Akkuch.
[Updated on: Mon, 16 June 2008 11:57] Report message to a moderator |
|
|
|
| Re: Values in different tables [message #327515 is a reply to message #327510] |
Mon, 16 June 2008 12:37  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
Reading your question, I'd say that the simplest way to do that would be to create a view (join these 3 tables) and base form data block on this view.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
