Hi, I am trying to create a form/subform where the main form would have the customer details and the subform would have service details.
Tables
------
I have 3 tables in my database:
1. Customer with the fields: CustomerID, lname, fname, address
2. ServiceType with the fields: ServiceTypeID, ServiceTypename
3. Service with the fields: ServiceID, CustomerID, ServiceTypeID, servicedate, servicetime, qty, desc
Relationships
-------------
Customer.CustomerID has a one-to-many relationship with Service.CustomerID. ServiceType.ServiceTypeID has a one-to-many relationship with Service.ServiceTypeID.
Form
----
On my main form I have the customer details with a combobox for the user to select the customer and the name etc. is populated. However, when I open the form, the customer info is already being populated - Don't know exactly why when it should be blank.
The subform has the service info. I want to be able to put a combo box for the servicetypename for the user to select and then the user will fill in the other details. This I am not getting to work. Also I want to be able to have more than one type of service for the same customer. Not getting this to work at all.
This is how I want my form to look
Customer ID 0001
Customer LName Customer Fname
Address
Service ID
Service Date
Service Time
------------------------------------------
ServiceTypeName QTY Desc
Rotation 0 Rotation Desc
Balance 2 Balance Desc
Any help would be appreciated.
Regards
Toukey
Tidak ada komentar:
Posting Komentar