subforms

[MEGDZIA]

Hello there!
As you were really helpful last time i would like to ask another question if you don't mind.:)
I have created a form Purchase Orders with subform PO1 for item, descriptions, qty and prices.It works fine when entering new records via form, but when i go to table Purchase Orders it doesn't look like all fields from subform are related to all fields from main form.
I mean each line in table should show:item, descr, qty, price (from subform) and ship from, deliver to (from main form)but it doesn't....
Do you think that you can help on this one????thank you very much:)


--------------------------------------------------------------------------------

[NeoPa]

It might help to explain which items (controls) are present in which of the forms. After all, we can't see what you have in front of you so we rely largely on what you tell us.

[MEGDZIA]

Main form (Purchase Order ) has got PO NO, Ship to Adress, Vendor Address, ,job Number, Tax Date and field: Target met?

The subform contains fields as follow: item, description, Qty, rate and delivery date.

when I'm trying to run a query which shows undelivered orders (when Target met?=No) it doesn't ahow vendors and PO No in every line...

[NeoPa]

Well, this doesn't really tell me much as there is no information as to which fields are linked between the main form and the subform, or even what matches what between the two forms.

Basically, you will need to ensure that all fields that you want duplicated throughout the records on the subform are linked to those you want them to be like on the main form.

It's a good idea only to link on those fields which are indexed though of course. Copying names or descriptions is not a recommended way to store data hierarchically. It is generally better to keep the data stored only once and link to it when required.

[MEGDZIA]

Thank you for your response. I'm sorry for this silly question but I don't really know how to link fields between main form and subform as can't build relationship( subform is not a table or query).......

[NeoPa]

No worries.

Check out a couple of things then come back if there's further explanation you need.

1. Create a Form/Subform pair using the Wizard. This will give you a bunch of ideas about how it works and what it does for you.
2. Check out the properties - Link Child Fields & Link Master Fields in the Subform/Subreport control which is a control on your main form which CONTAINS the subform.
3. Use F1 with the cursor in one of these properties to get a full explanation.