Table Populating

[Matt]

Here's my dilemma... I have two tables....

(1) "tbl_price" with columns "Price ID" (ie 500 - $39.95), "TicketQty" (ie
500), and "TicketCost" (ie $39.95).

(2) "tbl_ticket" with columns "Price ID", "TicketQty", and "TicketCost",
"and other ticket details".
*all fields are blank as this table is populated by "insert records" from
the website.

Within this website, on the "design" page, the user will choose from a drop
down menu a "PriceID" (ie 500 - $39.95) from the "tbl_price" table. On the
following "proof" page, the page will display the "TicketQty" (ie 500) and
"TicketCost" (ie $39.95) from the "tbl_ticket" table. So "TicketQty" and
"TicketCost" from "tbl_price" will populte "TicketQty" and "TicketCost" in
the "tbl_ticket" table.

Right now it's not working. I am by no means an expert with Access. Anyone
have any ideas? I appreciate your help in advance!

 

[Gina Whipp]

Matt,

I have read this post several times and I still don't get why you concerned
about having tbl_ticket populate when all the information you nned is in
tbl_price? You are storing it in tbl_ticket PriceID. You can get the
breakdown by using a query that joins tbl_ticket to tbl_price by PriceID.
No insertion query needed.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Matt]

Here's a little bit more detail...

I am displaying data in a list/menu on a page called "design". The menu is a
recordset retreiving data from "tbl_pricing". with the following table
structure:

PriceID (4, 5, etc...)
Selection (500 - $39.95, 1,000 - $44.95, etc...)
TicketQty ( 500, 1,000, etc...)
TicketCost ($39.95, $44,95, etc...)

Once the user chooses their "Selection" (ie "500 - $39.95", "1,000 -
$44.95", etc...) and a few other options, they can then verify their
selections on the next "proof" page that is retreiving data from "tbl_ticket"
with the following table structure:

TicketID
PriceID
Selection
TicketQty
TicketCost
- all other non related info

I am trying to get the choosen record from "tbl_pricing" to populate in
"tbl_ticket" so that when they view their "proof" the quantity and cost are
seperated for display and calculating reasons.

--
Thanks!
- Matt

Matt,

I have read this post several times and I still don't get why you concerned
about having tbl_ticket populate when all the information you nned is in
tbl_price? You are storing it in tbl_ticket PriceID. You can get the
breakdown by using a query that joins tbl_ticket to tbl_price by PriceID.
No insertion query needed.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Matt,

I agree with what you are doing but not the way... You just need it to show
not actually store in tbl_ticket.

Here I am on the web page...

I select my Ticket type (PriceID) from the look-up field in tblTicket. I
then go to the confirm page and view my selection which can view via Dlookup
and unbound fields but not actually store it in tbl_ticket. After I confirm
the only thing that needs to store in tbl_ticket is the PriceID. You can
still calculate on unbound fields as long as there is something in them to
calculate.

You do not want to store duplicate information in two tables unless you are
going to allow them to modify the quantity and/or price.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Here's a little bit more detail...

I am displaying data in a list/menu on a page called "design". The menu is
a
recordset retreiving data from "tbl_pricing". with the following table
structure:

PriceID (4, 5, etc...)
Selection (500 - $39.95, 1,000 - $44.95, etc...)
TicketQty ( 500, 1,000, etc...)
TicketCost ($39.95, $44,95, etc...)

Once the user chooses their "Selection" (ie "500 - $39.95", "1,000 -
$44.95", etc...) and a few other options, they can then verify their
selections on the next "proof" page that is retreiving data from
"tbl_ticket"
with the following table structure:

TicketID
PriceID
Selection
TicketQty
TicketCost
- all other non related info

I am trying to get the choosen record from "tbl_pricing" to populate in
"tbl_ticket" so that when they view their "proof" the quantity and cost
are
seperated for display and calculating reasons.

 

[Matt]

Gina,

I appreciate your reply... I really don't know the right way to do it. Would
I want to the values to be stored in tbl_ticket? Yes. I guess only because
tbl_ticket will store all of the uses input.