A form that presents data from same table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone
I have a form that "reads" from a qry that has 2 tables linked, clients and
process.That's info about a client and his procedures.
For the same procedure with just one cliente, i have to add another cliente
with same fields on that form. 2 clientes from same table with same procedure.
Any ideas or suggestions?
Tks in advance
Pedro
 
the two tables are linked via a common cross referenced field..... which is
identified by the relationship line one sees in the query design....

maybe it is just an ID number.....or a sales order number or something.....

but if you want the person's name in both table - then yes - you would need
to enter it twice.....

however you shouldn't ever need to do that because you have the cross
reference field.....thus in any report or other form you should always be
able to present the information from either/both tables that share the common
cross reference - - however you won't see it in the table....
 
Maybe i didn't explain myself but there aren't 2 tables... its the same one.
There's only one table...the thing is... i have to chose two persons or 3,
and should be able to see their adress and phone number ...The result is
NAME, ADRESS and PHONE 2 or 3 times ...any ideas?
 
Back
Top