Hi
Please can someone help me with this? I am very new to access and do not fully understand coding but I really want to learn so please be patient with me
Table: arpsFeedbackTbl
Fields: FeedbackID_Pk (AutoNumber)
CustomerID_Fk (Number)
OrderID_Fk (Number)
FeedbackDate (Date/Time)
Feedback (Text)
Table: arpsOrderTbl
Fields: OrderID_Pk (AutoNumber)
CustomerID_Fk (Number)
ServiceID-Fk (Number)
OrderDate (Date/Time)
Qty (Number)
Table: arpsServiceTbl
Fields: ServiceID_Pk (AutoNumber)
Service (Text)
CostPrice (Currency)
SalesPrice (Currency)
Documents1 (Text)
Documents2 (Text)
Documents3 (Text)
Documents4 (Text)
Documents5 (Text)
Table: arpsCustomerTbl
Fields: CustomerID_Pk (AutoNumber)
FirstName (Text)
Surname (Text)
IDNumber (Number)
ContactNumber (Text)
EmailAddress (Text)
The arpsFeedbackQry
The arpsFeedbackTbl
The arpsOrderTbl
The arpsServiceTbl
The arpsCustomerTbl
Please can you help with creating a Form to populate the arpsFeedbackTbl? Everything works, including the arpsFeedbackQry and arpsFeedbackRpt (not attached)
My problem is that the arpsFeedbackTbl consists of Fields with number references which makes it difficult to populate a form. Ideally what I want on the form is the following:
because the fields in thearpsFeedbackbl are mostly numbers and references I need the form to translate the actual information into those fields
eg: Surname: BUYS (when I type in BUYS, I need the CustomerID_Fk field in the arpsFeedbackTbl populated with the corresponding number 11)
PLEASE HELP