Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Child/Master Links in Access form/subform - limit?

Posted on 2013-01-03
7
Medium Priority
?
972 Views
Last Modified: 2013-02-24
Hello,
Is there a limit to the number of fields that a subform can link to a main form?  I have having issues with linking 5 different fields on a subform where all 5 fields are in the main form and hidden in the subform (all 5 fields are in both tables).

Thank you!
0
Comment
Question by:Monterey
  • 3
  • 2
  • 2
7 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38741774
is your problem showing records in the subform based on the 5 fields on the main form?

you have to understand that the subform records will be filtered using the combinations of the 5 fields from the main form using the "AND" operator.

in case like this, i used cascading combo boxes to filter the subform records.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38741907
I will admit to not knowing everything about relationships.
;-)

but...
I have seen situations where two tables were linked on 2 fields, but never more than this...

Can you take a moment to explain why a Parent/Child relationship would need *5* fields to link on?

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38742070
But please reply to capricon1's post first.
...as I may not be fully understanding your question here...
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Monterey
ID: 38744801
We are in the mushroom industry and what we are trying to do is have Harvesting estimates.  The unique part of the estimate is:  Date of Estimate, Farm, Sub-Farm, Date Estimate For and the time of the estimate.  Within that 'header' information, we have many rooms.  For example,
   Date of Estimate: 1/4/13
   Farm: ROK
   Sub-Farm: Building 1
   Date Estimate for: 1/4/13 or 1/5/13 or 1/6/13 (we estimate 3 days out)
   Time of Estimate: 6:00am or 11:00am or 2:00pm (we estimate 3 times a day)

Now for the detail:
  Room 104, Whites, 10000lbs (and more data)
  Room 105, Browns, 5000lbs

etc.

Hope that helps explain!
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38744842
what about the answer to the question posted above?
0
 

Accepted Solution

by:
Monterey earned 0 total points
ID: 38744986
Thought we did answer the question...however, we just did our own trouble shooting and turns out it is working fine...not sure how to explain why it works today and not yesterday, but that's Microsoft for ya!  Thanks for your time, but we did need the 5 linking fields and it is working now.
0
 

Author Closing Comment

by:Monterey
ID: 38922794
We were able to troubleshoot and find the answer ourselves
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question