| LOV query? [message #6537] |
Wed, 23 April 2003 18:08  |
Dean
Messages: 34
Registered: August 2000
|
Member |
|
|
Hi,
I have created the following tables: -
CREATE TABLE CUSTOMER(
cust_id number(7) not null unique,
surname char(15) not null,
forenames char(20) not null,
address1 char(35) not null,
address2 char(20) not null,
address3 char(15) not null,
address4 char(15) not null,
post_code VARchar2(7) not null,
tel_no VARchar2(12) not null,
email VARchar2(30) not null,
cust_user_name VARchar2(20) not null unique,
cust_password VARchar2(15) not null);
CREATE TABLE SEATING(
seating_id number(2) not null unique,
seating_spaces number(2) not null);
CREATE TABLE BOOKING(
cust_id number(7) not null references CUSTOMER(cust_id),
seating_id number(2) not null references SEATING(seating_id),
booking_id number(7) not null unique,
booking_time VARchar2(5) not null,
booking_date date not null);
CREATE TABLE MEAL(
booking_id number(7) not null unique references BOOKING(booking_id),
meal_id number(7) not null unique,
starter char(15),
main char(15),
dessert char(15));
I am trying to assign an LOV, or find a way that stores the booking.booking_id into the meal.booking_id, any ideas?
thanks
|
|
|
|
| Re: LOV query? [message #6956 is a reply to message #6537] |
Tue, 13 May 2003 12:00  |
Stephen
Messages: 26
Registered: January 2000
|
Junior Member |
|
|
|
You didn't give much information so I'll just assume you're in forms, at least 6.0. I assume you're looking to populate one when the other is populated. Method one would be to parent/child the blocks together based on booking_id. When one populates so will the other. If you have a list based on booking, then you can syncronize the fields together as long as they are in the same block. Lastly an LOV based on booking you can assign it to the field for meal to popup automatically and force any inputs to be verfied on the list. Hope that helps.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
