Prev: Problem with Group By & Max Rcd
Next: Are rows stored in fixed or variable length records.
From: John... Visio MVP on 8 Feb 2010 21:03
"Steve" <notmyemail(a)address.com> wrote in message
news:%23ocoFASqKHA.6064(a)TK2MSFTNGP02.phx.gbl...
> Hello Mark!
>
> You deserve an A+ for Stick-To-It ness for working on the database for
and an F if he accepts your offer.
> several years. However, wouldn't it be a relief to get it done and move
> on?
how about it if you moved on?
> I would like to offer to work with you and finish your database. I provide
> help with Access, Excel and Word applications. My fee to finish the
> database with you would be very reasonable. Contact me and let's get it
> done!!!
>
> Steve

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP


From: StopThisAdvertising on 9 Feb 2010 03:13

"Steve" <notmyemail(a)address.com> schreef in bericht news:%23ocoFASqKHA.6064(a)TK2MSFTNGP02.phx.gbl...
> Hello Mark!
>
> You deserve an A+ for Stick-To-It ness for working on the database for several years. However, wouldn't it be a relief to get it
> done and move on? I would like to offer to work with you and finish your database. I provide help with Access, Excel and Word
> applications. My fee to finish the database with you would be very reasonable. Contact me and let's get it done!!!
>

--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.000 pageloads... it's a shame !!)

Arno R


From: CuriousMark on 10 Feb 2010 11:21
yes, but that's not the problem. The problem is to select or add a new
customer.

"PieterLinden via AccessMonster.com" wrote:

> Are you using the LinkChild/LinkMaster properties in your subform?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1
>
> .
>
From: CuriousMark on 10 Feb 2010 11:21


"KARL DEWEY" wrote:

> >>The subform is linked to the main form through the OrderID field.
> How can this be as your query for main form does not have OrderID field.

The OrderID field is autonumber generated as soon as data is entered in the
form.
>
> >>how to search based on the entry for an existing customer,
> Use a combo to select customer.
>
> Main form – tblOrders - tblCustomers
> Combo – select customer
> Enter OrderDate - automatic generate OrderID
> - required delivery - payment - shipping method - etc.

how do I have it add a new customer if the customer doesn't exist?
>
> Make sure you set the Master/Child links on form/subform on OrderID.
>
> Subform – tblOrderProd - tblOrders - tblProducts
> Combo – select product
> QTY – Size – Color -
>
> --
> Build a little, test a little.
>
>
> "CuriousMark" wrote:
>
> > I have been working on this database for several years, learning as I go.
> > However I have been stuck on the problem of the best way to design a form for
> > data entry into three tables. I now give up and put the whole thing on the
> > Forum in the hope that someone can help me with the design. For simplicity, I
> > will illustrate using the "Order Entry" style database, and limit the fields
> > to only those necessary.
> >
> > There are four tables with the following fields:
> >
> > tblCustomers - CustomerID (pk), CustomerName
> > tblOrders - OrderID (pk), OrderDate, CustomerID (fk)
> > tblOrderProd - OrderProdID (pk), OrderID (fk), ProductID (fk)
> > tblProducts - ProductID (pk), ProductName
> >
> > One customer is associated with one or more orders, and one order can have
> > one or more products. The user should be able to create a new order by
> > specifying the date and the customer, and then one or more products.
> >
> > I have a main form with subform to do this. The main form is bound to a
> > query that joins the tblOrders and tblCustomers tables, and the subform is
> > bound to a query that joins the tblOrderProd and tblProducts tables. The
> > subform is linked to the main form through the OrderID field.
> >
> > Main form query:
> > SELECT tblOrders.OrderDate, tblCustomers.CustomerName
> > FROM tblCustomers INNER JOIN tblOrders
> > ON tblCustomers.CustomerID = tblOrders.CustomerID
> >
> > Subform query:
> > SELECT tblOrderProd.ProductID, tblProducts.ProductName, tblOrderProd.OrderID
> > FROM tblProducts INNER JOIN tblOrderProd
> > ON tblProducts.ProductID = tblOrderProd.ProductID
> >
> > This setup works great for adding records, and when I enter a ProductID in
> > the subform it will show the ProductName but the problem is that this design
> > means a new customer is added for each new order: I can't figure out how to
> > search based on the entry for an existing customer, use it if it exists, or
> > add it if it is new.
> >
> > My hunch is that I should unbind both forms, using Append queries to enter
> > the data in the related three fields. If so, then how do I find out the new
> > OrderID to use to append to tblOrderProd? And how do I find out the
> > CustomerID to use to append to the tblOrders if it is a new Customer? Then
> > how do I progress through each ProductID entered in the subform when
> > appending to the tblOrderProd table?
> >
> > Thanks very much.
> >
From: CuriousMark on 10 Feb 2010 11:23
Steve,

Thanks but not thanks. I guess you don't understand.....I wouldn't have
learned as much as I have if I just hired someone else to do it for me. That
takes all the fun and learning out of it.

"StopThisAdvertising" wrote:

>
> "Steve" <notmyemail(a)address.com> schreef in bericht news:%23ocoFASqKHA.6064(a)TK2MSFTNGP02.phx.gbl...
> > Hello Mark!
> >
> > You deserve an A+ for Stick-To-It ness for working on the database for several years. However, wouldn't it be a relief to get it
> > done and move on? I would like to offer to work with you and finish your database. I provide help with Access, Excel and Word
> > applications. My fee to finish the database with you would be very reasonable. Contact me and let's get it done!!!
> >
>
> --
> Get lost $teve. Go away... far away....
>
> Again... Get lost $teve. Go away... far away....
> No-one wants you here... no-one needs you here...
>
> This newsgroup is meant for FREE help..
> No-one wants you here... no-one needs you here...
> OP look at http://home.tiscali.nl/arracom/whoissteve.html
> (Website has been updated and has a new 'look'... we have passed 11.000 pageloads... it's a shame !!)
>
> Arno R
>
>
> .
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Problem with Group By & Max Rcd
Next: Are rows stored in fixed or variable length records.