Inserting Table Data into a seperate form

  • Thread starter Thread starter J Warren
  • Start date Start date
J

J Warren

Hello,

Could I please get some help about placing data from TABLE_B into a
Form that uses TABLE_B? I have created a form that displays data from
TABLE_B that I would like to also display some data from TABLE_A
without using a sub-form, if possible. I've seen it done in the Event
Registration sample DB, but I have been unable to replicate how it was
done. I'm missing some thing some where. Any pointers?

Thank you,
J. Warren
 
Hello,

Could I please get some help about placing data from TABLE_B into a
Form that uses TABLE_B? I have created a form that displays data from
TABLE_B that I would like to also display some data from TABLE_A
without using a sub-form, if possible. I've seen it done in the Event
Registration sample DB, but I have been unable to replicate how it was
done. I'm missing some thing some where. Any pointers?
Click to expand...

Well, give us some help. How are TABLE_A and TABLE_B related? How can
you determine for a given TABLE_B record which record from TABLE_A you
want to display? Do you want to just display it, or edit TABLE_B as
well?
 
John Vinson said:
Well, give us some help. How are TABLE_A and TABLE_B related? How can
you determine for a given TABLE_B record which record from TABLE_A you
want to display? Do you want to just display it, or edit TABLE_B as
well?
Click to expand...

Hello John,

This is were I am stuck. I'm still wet behind the ears and am not sure
exactly how tables should be related. TABLE_A and TABLE_B have the
ClientID field in common and are related using a One-To-Many relation.
Currently I am using a sub-form on TABLE_B to display two fields from
TABLE_A (DATE & AMOUNT). I'm trying to display the DATE & AMOUNT
fields from TABLE_A inside a text field within TABLE_B for editing.
Eventually, I would like to edit some fields from TABLE_A from the
TABLE_B Form. Should I rethink my question so it is understandable?

Thank you,
J. Warren
 
Hello John,

This is were I am stuck. I'm still wet behind the ears and am not sure
exactly how tables should be related. TABLE_A and TABLE_B have the
ClientID field in common and are related using a One-To-Many relation.
Currently I am using a sub-form on TABLE_B to display two fields from
TABLE_A (DATE & AMOUNT). I'm trying to display the DATE & AMOUNT
fields from TABLE_A inside a text field within TABLE_B for editing.
Eventually, I would like to edit some fields from TABLE_A from the
TABLE_B Form. Should I rethink my question so it is understandable?
Click to expand...

Yes, I'm afraid you should. Your subform is "upside down" - normally
one would use a Form based on the "one" side table (Table_A) with a
Subform based on the "many" (Table_B). This will let you display any
of the fields from TableA, on the mainform, editable; and on the
subform you'll see either a single record from Table_B, which can be
scrolled (if you set the subform to Single Form view), or a bunch of
Table_B records (if you use Continuous or Datasheet view).

Upside down subforms *occasionally* have their uses, but they're
uncommon. If you do want to do this, you'll need to make the Table_B
form a Single form (not continuous), and use ClientID as the
Master/Child Link Field. Of course, editing the date and amount field
in TableA from one record of TableB will change it for all records for
that client, since there's only one Date and one Amount field.

You say "display the DATE & AMOUNG fields from TABLE_A inside a text
field within TABLE_B for editing" - and this is the part that doesn't
make sense. The fields aren't IN Table_B! They're in Table_A. Should
they be in Table_B instead? If table_A contains client information,
and Table_B contains transactions for that client, then the date and
amount of the transaction should - I'd say MUST - be in Table_B!
 
Back
Top