insert data into different tables

[fazdebuzz]

I have created two tables Films and Expenses.

The variables Films table – FilmsID, MovieTitle, PitchText, AmountBudgeted, RatingID, Summary, and DateInTheathers

And in Expenses table – ExpenseID, FilmsID, ExpenseAmount, Description, ExpenseDate.

FilmsID need to be entered to these two tables as it’s the unique id.

I can’t find the easiest way to do so.
Help pleaseeee :\

p/s: I’m a newie to coldfusion. Sobs

[hemaldazzle]

you take both id in primery key and Expenses table in take one forign key

[lyodmichael]

i think this article will help, http://bytes.com/topic/access/insigh...ble-structures

[fazdebuzz]

is it working if i am using cold fusion and oracle database?