Hi Toukey,
I have uploaded a sample file for you that may help easier than trying to explain it. It is not polished but I trust it will help. If you have any questions please let me know.
The file is named ExampleMasterDetail.zip and it is in the Files > 2_AssistanceNeeded folder.
Kind Regards,
Pat Wood
http://accesstips.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, toukey1 <no_reply@...> wrote:
>
> Sure no problem.
>
> --- In MS_Access_Professionals@yahoogroups.com, "patrickawood" <pwood57@> wrote:
> >
> > Hi Toukey,
> >
> > I have to be gone for about an hour but I will get back to you when I can.
> >
> >
> > Kind Regards,
> > Pat Wood
> > http://accesstips.wordpress.com
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, toukey1 <no_reply@> wrote:
> > >
> > > 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