G
Guest
To all you MS-Access gurus out there, thank you very much in advance for your
help.
I am trying to create a Form containing a Subform. The Form is based on a
table (Vendors) with the fields VendorID (primary key) and VendorName. The
Subform I am trying to create contains the fields contained in a query that
combines at least 3 other linked tables The first table (Contracts) contains
a ContractID (primary key) and the VendorID (foreign key). The second table
(Repname) contains sales rep ID (primary key), sales rep names ( first name
and last name), ContractID (foreign key) and VendorMgrSubGrpID (foreign key)
and the third table (VendorMgrSubGrp) contains VendorMgrSubGrpID (primary
key) and the sales rep team description (VendorMgrSubGrpCode).
All the tables are linked as follows:
Vendors:Contracts = 1:many
Contracts: Repname = many:many via a Junction table
RepName:VendorMgrSubGrp = many:1
I am experiencing the following difficulties:
1) I am unable to change (edit) values of any of the fields in the subform
2) If I actually were able to amend the VendorMgrSubGrpCode displayed in the
subform, how can I present a list of the available VendorMgrSubGrpCodes (held
in VendorMgrSubGrp table) for the user to select from, and how can the
VendorMgrSubGrpID corresponding to the selected VendorMgrSubGrpCode replace
the original VendorMgrSubGrpID stored in the Subform, the query behind the
Subform, and the Repname table sitting behind the query?
3) When I wish to select another VendorID in the parent form, how can I make
the VendorName (also displayed in the parent form) change to the new
corresponding Vendor Name?
4) How can I change the format of the subform (presently datasheet) to
another format (e.g. column/tabular)?
Unfortunately I am not a coder, so would like to avoid resorting to this if
at all possible.
Your sage advice would be greatly appreciated.
P.S. I have created a small example database containing all these elements
if you need to analyse it.
Kind Regards,
vykc00
help.
I am trying to create a Form containing a Subform. The Form is based on a
table (Vendors) with the fields VendorID (primary key) and VendorName. The
Subform I am trying to create contains the fields contained in a query that
combines at least 3 other linked tables The first table (Contracts) contains
a ContractID (primary key) and the VendorID (foreign key). The second table
(Repname) contains sales rep ID (primary key), sales rep names ( first name
and last name), ContractID (foreign key) and VendorMgrSubGrpID (foreign key)
and the third table (VendorMgrSubGrp) contains VendorMgrSubGrpID (primary
key) and the sales rep team description (VendorMgrSubGrpCode).
All the tables are linked as follows:
Vendors:Contracts = 1:many
Contracts: Repname = many:many via a Junction table
RepName:VendorMgrSubGrp = many:1
I am experiencing the following difficulties:
1) I am unable to change (edit) values of any of the fields in the subform
2) If I actually were able to amend the VendorMgrSubGrpCode displayed in the
subform, how can I present a list of the available VendorMgrSubGrpCodes (held
in VendorMgrSubGrp table) for the user to select from, and how can the
VendorMgrSubGrpID corresponding to the selected VendorMgrSubGrpCode replace
the original VendorMgrSubGrpID stored in the Subform, the query behind the
Subform, and the Repname table sitting behind the query?
3) When I wish to select another VendorID in the parent form, how can I make
the VendorName (also displayed in the parent form) change to the new
corresponding Vendor Name?
4) How can I change the format of the subform (presently datasheet) to
another format (e.g. column/tabular)?
Unfortunately I am not a coder, so would like to avoid resorting to this if
at all possible.
Your sage advice would be greatly appreciated.
P.S. I have created a small example database containing all these elements
if you need to analyse it.
Kind Regards,
vykc00