Bruno Santos wrote:
I'm trying to develop a sort of application with base. I've draw some
forms and some tables. the tables are all related in the relations
options.
my question is:
i've a table with an id and another one with other information but
related with the previous with the id.
Just so I understand, I assume the following fields
Table_1 has field id_1
Table_2 has field id_2
Table_2 refers to id_1 in Table_1
in the form for the 2nd table, i need that the user inserts the id and
in another control and i need a sql query to get to the 1st table and
retrieve some information related with that id (the one the user
inserts in previous control).
I do not really understand.... Using sql, I can write something like this:
select * from Table_1 where id_1=7
Based on what you have said, howeer, I assume that you are using a form.
Because of this, I would do something like this....
Form_Master contains some field that corresponds to the value in id_1 in
Table_1.
Insert Form_New INSIDE of Form_Master. I would then link Form_New to
Form_Master using using id_1 from Table_1 to the corresponding field in
the Form_Master. Now, Form_New should update automatically. It works
very well.
ive tried with the query editor, but i cant understand that. how can i
refer a form field in a SQL query ?
I have never done this with a query...
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
