N
Nancy
Hi -
Just wanted to know if I doing this the correct way. My user wants a form
which they will enter a item number from table A. A desc also from table A
will be displayed.
Item:xxxxx desc:xxxxxxxxxxxxxxxxxxxxxxxxxxx
There is a one to many relationship with table B based upon the item number.
They would like to see associate data from this:
Item Quanity Unit etc.
yyyy yyyyy yyy yyy
yyyy yyy yyy
yyyy yyyyy yyy yyy
yyyy yyy yyy
.....
Okay so here is where I am at: I placed Item and Desc (from table A) in the
header record and the table B data in the detail record.
I would like the data in Table B to be display only (can that be done?)
I would like all of the matching data to be displayed at one time (can be
from 1 to n rows).
I was going to create a button near table A and to clear the entire form and
execute a find (am I on the right track)?
Is there a better way to do this? I am a little lost with this one.
Thanks,
Nancy
Just wanted to know if I doing this the correct way. My user wants a form
which they will enter a item number from table A. A desc also from table A
will be displayed.
Item:xxxxx desc:xxxxxxxxxxxxxxxxxxxxxxxxxxx
There is a one to many relationship with table B based upon the item number.
They would like to see associate data from this:
Item Quanity Unit etc.
yyyy yyyyy yyy yyy
yyyy yyy yyy
yyyy yyyyy yyy yyy
yyyy yyy yyy
.....
Okay so here is where I am at: I placed Item and Desc (from table A) in the
header record and the table B data in the detail record.
I would like the data in Table B to be display only (can that be done?)
I would like all of the matching data to be displayed at one time (can be
from 1 to n rows).
I was going to create a button near table A and to clear the entire form and
execute a find (am I on the right track)?
Is there a better way to do this? I am a little lost with this one.
Thanks,
Nancy