Home » Developer & Programmer » Forms » Values in different tables (Forms 10, XP)
icon1.gif  Values in different tables [message #327510] Mon, 16 June 2008 11:52 Go to next message
Messages: 1
Registered: June 2008
Junior Member

Hi. Embarassed

There are this tables in my database:
(-clients-)    [id]
[id]-----------[client_id]     (-events-)
[name]         [event_id]------[id]            

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 Go to previous message
Messages: 21148
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.
Previous Topic: migration
Next Topic: print pdf file using webutil
Goto Forum:

Current Time: Sat Aug 19 21:23:16 CDT 2017

Total time taken to generate the page: 0.22724 seconds