help creating feedback form

[Peter Simpson]

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

[aytee111]

When carrying keys across tables, they are done using comboboxes. For instance, a combobox for a customer will have a row source query which has SELECT PK, name FROM arpsCustomerTbl. That has two columns, the first column is the bound column (these are properties for the combobox). The first column will be hidden so all the user sees is the customer name, but the first column is the one that is stored on the table. The control source will be set to the corresponding field name on the table.

[Peter Simpson]

Hi ayte111

Thank you for that...somehow I managed to bungle my way through and it works....I just need to keep going through the design view and keep on refreshing my memory. thanks again