What is a LinkMasterfield? Linkchildfield?

  • What is LinkedMasterField
    LinkedChildField?


    Is the LinkedMasterfield a table and the linkedchildfield a query or subform?


    thanks

  • Re: What is a LinkMasterfield? Linkchildfield?


    It could relate to a subform, graph, etc. Any child object that is bound to it's parents 'master' recordset should have the property. For example, say you have a report that displays one item number's sales history per page and a sales history graph is on the report just below the data section. The parent recordset is that of the reports source table or query. Let's say the report uses a query called 'REPORT_QUERY_1'. The graph may or may not have the same record source. Let's say the graph's record source is 'GRAPH_QUERY_1'. To bind these two objects parent and child together so that the report data and the graph data for item X are diplayed appropriately we use the two properties you discussed in the graph object. The property on the graph object for LinkedMasterfield is the [REPORT_QUERY_1].[ITEM_NUMBER]. The property on the graph object for LinkedChildfield is the [GRAPH_QUERY_1].[ITEM_NO]. I made the two field names different on purpose, but they are the key, the join, the link between these two recordsets and objects contained on the report.


    hope that helps,

    :guitar: - Scott

  • Re: What is a LinkMasterfield? Linkchildfield?


    Thanks W Scott.


    This property only applies if there is a set of two or more objects where one is the source and the other has been created (or relies) on the source information?


    Looking at Access Help I read something about option buttons (or activex controls). How does these fit into your model about LinkedMasterfield and LinkedChildfields?


    In this type of parent-child relationship, updates to the source will automatically update the linkedchild but updates to the linkedChildfield will not update the LinkedMasterfield?


    Thanks

  • Re: What is a LinkMasterfield? Linkchildfield?



    I have not used activeX controls in this context. My experience is limited to subforms and graphs. I am not sure I follow your question concerning updates. Sorry.

    :guitar: - Scott

  • Re: What is a LinkMasterfield? Linkchildfield?


    Thanks for the update W Scott


    Disregard the first part of the last question. Can you answer this one:


    In this type of master-child relationship, updates to the source (report) will automatically update the linkedchild (graph) but updates to the linkedChildfield will not update the LinkedMasterfield?


    Or is the report the child and the graph the master. Either way, can only one be updated and consequently update the other?

  • Re: What is a LinkMasterfield? Linkchildfield?


    Quote from bearcub


    In this type of master-child relationship, updates to the source (report) will automatically update the linkedchild (graph) but updates to the linkedChildfield will not update the LinkedMasterfield?


    If I understand your question correctly the parent absolutely forces the child to update. We could really see this more clearly perhaps if we were talking about a form where the user moves from item to item. As the user changes items and the parent form updates the basic item information, and the child graph of sales history follows.

    :guitar: - Scott

  • Re: What is a LinkMasterfield? Linkchildfield?


    Thank you again,


    i guess the other question is can the child force the Parent (master) to update? If so, does it happen all the time or does it depend upon the type of query (subform) being used?

  • Re: What is a LinkMasterfield? Linkchildfield?


    Quote from bearcub

    i guess the other question is can the child force the Parent (master) to update? If so, does it happen all the time or does it depend upon the type of query (subform) being used?


    I am not sure why you would want the child to force the parent to update, but I think you would have to change their relationship. I think it probably only works one way.


    If you are talking about editing records through a subform that is a different story...

    :guitar: - Scott

  • Re: What is a LinkMasterfield? Linkchildfield?


    Sorry, didn't mean to confuse you.


    I was just trying to understand the concept. We have a commissions database at work that lists a number of queries for mapping revenues to sales people. In this database are a couple of tables that show what customers have not been mapped to salesman for whatever reason. A third table is provided that will allows the user to correct the territory mapping. Access would only allow me to remap the customers to the correct territory only thru the detail table, not the first two tables. That was when I was asking. Maybe the first two are not tables but actually queries whereas the "Detail" table is actually a table, not a query.


    Am I making sense in describing?

  • Re: What is a LinkMasterfield? Linkchildfield?


    I see, sometimes it is difficult to structure queries for subforms that will allow updating in that fashion. It depends on the joins. Also the query property for recordset type will need to be Dynaset (Inconsistent Updates) in most cases before that type of update will work.

    :guitar: - Scott

  • Re: What is a LinkMasterfield? Linkchildfield?


    I see,


    the intent was to only allow the user to update only one table, not all three. So, in the properties they must have not allowed the table/query to be updated, correct?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!