Need major help - mutli-block canvas
Posted on 2003-12-10
OK---i posted this problem earlier but we could not get it fixed. I will give as much detail as I can think to give.
Problem: When I go from my checkin canvas to my guest_bill canvas, the tabular data block (guest_trans2) does not fill with the room service items.
Setup: When at checkin canvas...hit checkout...takes data and places it in the Guest_Bill canvas. The guest_bill canvas has three data blocks on it (Guest_Bill, Checkin1, Guest_Trans2). Checkin1 fields are fname, lname which are filled from the previous canvas (this works). Guest_Bill fields are Bill_ID, emp_num, depart_date, room_num, room_total, trans_total, tax, total. depart_date, emp_num, room_num fill from the previous canvas (this works). Guest_Trans2 is tabular with fields room_num, description, trans_date, rate.
This is merely a list of all transactions from that room_num. This is not populating. It needs to populate from the guest_bill.room_num.
All data_block are control blocks (I think - Property -> Database Data Block = Yes)
I figured I need something like changing one from a control block to a data block...adding a where clause...and have it execute somehow.
I really need some help here