Re: 2nd try: have default items on every report
- From: JD <JD@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Dec 2006 07:26:02 -0800
I will try and respond to both of yours here. Here's the real world
situation. We are selling plants to customers. Orders are printed up by
date range on delivery date. On every order report, our managers want to
list 60 default plants so that if last minute request are made the delivery
person can write them on the form and later be put in the database. I have
the plantDescriptions pulled from the PlantList Table. and there is a 1 to
many relationship between the Customer Info Table and the Orders Table.
Customer Info Table
TrackingNumber <primary Key>
Name <text>
Address<text>
Orders
LineNumber <Primary Key>
TrackingNumber <int>
PlantDescription <text>
Qty <int>
DelDate <date>
PlantList
PlantDescription <text>
I have a form created
--
JD
"BruceM" wrote:
I forgot about wanting 60 items on every invoice whether or not the item is.
sold. You could probably do that with labels for each item, and VBA code to
display values in unbound text boxes next to the labels, or something like
that, but the point of listing all 60 items on every order (if that is the
situation) is lost on me.
"JD" <JD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2600007A-B1E1-45CF-808B-B4B92DA01FB4@xxxxxxxxxxxxxxxx
Sorry, I am still getting the hang of formatting the text correctly. Here
is
what the tables look like:
Table1
TrackingNumber <primary key>
Name <text>
Address <text>
Table2
TrackingNumber
ItemDescription <text>
Qty <smallint>
LineNumber <Primary Key>
Table3
ItemDescription <text>
--
JD
"JD" wrote:
I am sorry I was extremely confusing. Let me try this again.
I have three tables as listed below:
Table1 Table2
Table3
TrackingNumber <primary key> TrackingNumber <int>
ItemDescription
Name <text> ItemDescription <text>
Address <text> Qty <smallint>
LineNumber <Primary Key>
What we have are reports that are printed for every order in a specified
date range. They want the default 60 items printing on every report even
if
there are no quantities. If there are quantities, they would like these
numbers printed on the report as well and have them recorded in Table2.
I am
really not sure how to accomplish this without creating a lot of data
that
takes up space.
Please let me know if I need to give more info.
Thanks for you help and patience.
--
JD
- Follow-Ups:
- Re: 2nd try: have default items on every report
- From: BruceM
- Re: 2nd try: have default items on every report
- References:
- Re: 2nd try: have default items on every report
- From: BruceM
- Re: 2nd try: have default items on every report
- Prev by Date: Re: 2nd try: have default items on every report
- Next by Date: Re: Update Second Table from Form
- Previous by thread: Re: 2nd try: have default items on every report
- Next by thread: Re: 2nd try: have default items on every report
- Index(es):
Relevant Pages
|
