Hi,
This is the subform record source:
SELECT Service.ServiceID, Service.[Service date], Service.[Service time], Service.Quantity, Service.T_DescriptionID, ServiceType.ServiceTypeID, ServiceType.ServiceName, Service.CustomerID
FROM ServiceType INNER JOIN Service ON ServiceType.[ServiceTypeID] = Service.[ServiceTypeID];
This is the rowsource for the servicetypename combo box:
SELECT ServiceType.ServiceTypeID, ServiceType.ServiceName
FROM ServiceType
ORDER BY ServiceType.[ServiceName];
Thanks for your assistance.
Toukey
--- In MS_Access_Professionals@yahoogroups.com, "patrickawood" <pwood57@...> wrote:
>
> Hi Toukey,
>
> Can you post the the Subform's RecordSource for us? If it is a Query can you post the Query's SQL?
>
> Also can you post the Subform servicetypename combo box's RowSource SQL or Query SQL for us?
>
> Kind Regards,
> Patrick Wood
> http://accesstips.wordpress.com
>
>
> --- In MS_Access_Professionals@yahoogroups.com, toukey1 <no_reply@> wrote:
> >
> > 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