OraFAQ Forum: Forms » LOV query

Home » Developer & Programmer » Forms » LOV query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LOV query [message #82116]

Wed, 23 April 2003 18:06

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 that stores the booking.booking_id into the meal.booking_id, any ideas?

thanks

Report message to a moderator

Re: LOV query [message #82141 is a reply to message #82116]

Mon, 28 April 2003 02:32

shadow
Messages: 15
Registered: April 2003

Junior Member

U have to create a record group which query is
select booking_id from meal
then create a lov which based on this record group and assign column maping which field do u want that's it.

Report message to a moderator

Previous Topic:	differences
Next Topic:	Tab label

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 13:32:02 CDT 2024