Solved

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

Posted on 2013-01-03
7
885 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 119

Expert Comment

by:Rey Obrero
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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 119

Expert Comment

by:Rey Obrero
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

895 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now