By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

subforms

P: 27
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:)


--------------------------------------------------------------------------------
Apr 24 '08 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,186
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.
Apr 24 '08 #2

P: 27
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...
May 1 '08 #3

NeoPa
Expert Mod 15k+
P: 31,186
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.
May 1 '08 #4

P: 27
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).......
Jun 17 '08 #5

NeoPa
Expert Mod 15k+
P: 31,186
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.
Jun 18 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.