Partial duplicate information on sequential rows on a form.

S

SoDakRah

I want to have any duplicate information on row 1 and row 2 to not appear on
the form. This information comes from 2 SQL tables A and B
The row displays information as A1(table.field), A2, A3, B1, B2
On the first row I want all information.
On the second row A1, A2, A3 are duplicate of the first row and I want that
data to not show, just show B1 and B2 which will be different.
Any ideas?
 
S

SoDakRah

Sorry this is on a form. Table A is static and table B has many record
associated to one record in table A. The form will allow the user to enter
data into table B. I do not see a hide duplicates property or is this a VB
command during the form_load?
 
K

KARL DEWEY

Use a form/subform for TableA/TableB and set Master/Child links on common
field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top