Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-01-03
7
Medium Priority
?
946 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
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.

 

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

Industry Leaders: 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!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

636 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