Hi,
I am new to the forums, but I liked some of the responses I have seen so here is my question.
I have created several tables which link to an Entry Form, on which I have a couple questions which I hope someone can help me with. I will describe the schema below. Some of the names have been changed because of the sensitivity of the info. (Part B is basically a grouping of Part A's, and also has revisions)
Tbl1 - PartTypeA
PartA_UniqueID
PartName
PartNum (PK)
Manufacturer (PK)
Tbl2 - PartTypeB
PartB_PK (PK)
PartName
PartNum
Tbl3 - PartTypeBRev
PartBRev_UniqueID
PartB_FK (PK)
PartBRevision (PK)
Tbl4 - PartTypeA_PartTypeBRev
PartAPartBRev_UniqueID
PartA_ForeignUniqueID
PartBRev_ForeignUniqueID
Qty
So my first question is this. If I have a form which displays Part B's, the underlying Part A's and B's in subforms, and I want a list box to display only the revisions applicable to that particular Part B, how do I accomplish this?
My next question is know may involve some sort of VB code to accomplish, so I assume it may be more difficult. If I wish to copy all the children of a particular Part B when starting a new revision of it, so that the new revision starts off looking like the previous one, how can one do this?
Any help will be appreciated.
Thanks.
I am new to the forums, but I liked some of the responses I have seen so here is my question.
I have created several tables which link to an Entry Form, on which I have a couple questions which I hope someone can help me with. I will describe the schema below. Some of the names have been changed because of the sensitivity of the info. (Part B is basically a grouping of Part A's, and also has revisions)
Tbl1 - PartTypeA
PartA_UniqueID
PartName
PartNum (PK)
Manufacturer (PK)
Tbl2 - PartTypeB
PartB_PK (PK)
PartName
PartNum
Tbl3 - PartTypeBRev
PartBRev_UniqueID
PartB_FK (PK)
PartBRevision (PK)
Tbl4 - PartTypeA_PartTypeBRev
PartAPartBRev_UniqueID
PartA_ForeignUniqueID
PartBRev_ForeignUniqueID
Qty
So my first question is this. If I have a form which displays Part B's, the underlying Part A's and B's in subforms, and I want a list box to display only the revisions applicable to that particular Part B, how do I accomplish this?
My next question is know may involve some sort of VB code to accomplish, so I assume it may be more difficult. If I wish to copy all the children of a particular Part B when starting a new revision of it, so that the new revision starts off looking like the previous one, how can one do this?
Any help will be appreciated.
Thanks.