G
Guest
Please bear with me for the basic questions. See explanation below for
reasons I'm posting anyway.*
I'm tracking our products for kosher status & proprietary status, using
Access 2003.
Tbl Briefs: "Brief#"; "Item#"
Tbl CustIDs: "Possible Customer Name"; "CustID"
Tbl Proprietary: "Item#"; "Proprietary Customer"
TblMain ITEMS: Primary Key "Item#"; "Item Name"; "KStatus"; "CustID"
Item# joined 1:M from TblMain ITEMS:Tbl Briefs but Join Properties has All
records from ITEMS, some records from Briefs
Frm DATA ENTRY w/SubFrm Briefs
Goal: Input Item#, Item Name, Kosher Status, Proprietary customer in DATA
ENTRY
User chooses from list of possible customer names, which returns the proper
custID. Briefs including that Item# listed.
Problems: (after many many permutations)
1) not permitted to delete CustID from tblITEMS, due to a relationship which
I deleted long ago;
2) Form keeps asking for parameters every time I try to look at anything;
3) When I did try to use tblCustIDs as row source for tblITEMS.CustID, no
matter what I put for bound columns & number columns & column widths, it
always retained Possible Customer Name, not the actual CustID.
4) usually can only establish "indeterminate" relationships, whether I show
tables & drag fields or Create New relationship
*Working as a temp in a company w/no trained Access users; limited in how
many hours I can study up on this. Have tried Access manual, Northwind &
Garden Company tutorials on my own time. Can't use more company time
continuing to search discussion posts & other links posted by MVP's.
reasons I'm posting anyway.*
I'm tracking our products for kosher status & proprietary status, using
Access 2003.
Tbl Briefs: "Brief#"; "Item#"
Tbl CustIDs: "Possible Customer Name"; "CustID"
Tbl Proprietary: "Item#"; "Proprietary Customer"
TblMain ITEMS: Primary Key "Item#"; "Item Name"; "KStatus"; "CustID"
Item# joined 1:M from TblMain ITEMS:Tbl Briefs but Join Properties has All
records from ITEMS, some records from Briefs
Frm DATA ENTRY w/SubFrm Briefs
Goal: Input Item#, Item Name, Kosher Status, Proprietary customer in DATA
ENTRY
User chooses from list of possible customer names, which returns the proper
custID. Briefs including that Item# listed.
Problems: (after many many permutations)
1) not permitted to delete CustID from tblITEMS, due to a relationship which
I deleted long ago;
2) Form keeps asking for parameters every time I try to look at anything;
3) When I did try to use tblCustIDs as row source for tblITEMS.CustID, no
matter what I put for bound columns & number columns & column widths, it
always retained Possible Customer Name, not the actual CustID.
4) usually can only establish "indeterminate" relationships, whether I show
tables & drag fields or Create New relationship
*Working as a temp in a company w/no trained Access users; limited in how
many hours I can study up on this. Have tried Access manual, Northwind &
Garden Company tutorials on my own time. Can't use more company time
continuing to search discussion posts & other links posted by MVP's.