A couple of Newbie Question, getting frustrated!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello all, any help is greatly accepted!

The background is, I am trying to make a database where the user only sees
my user forms when he/she loads access. Its going to have many modules, but
the first one is bascially a budget (which could be done in excel but I want
to learn access!).

I have one very quick question - at the bottom

If you bear with me, here is my table - schema and below i will post my
questions!

Job List
Job# (KEY)
Position
Location
Salary
Hourly Pay
Shift Style
Hours Per Day
Boss 1
Boss 2
Other Income
DO#
DO# (optional, RSPS)

Debts and Owing
DO# (KEY)
Translist #
Name
Amount (Total)
S. Date
E. Date
Notes
Amount Paid
Income/ EXP
Paid off?

Transactions
Trans# (KEY)
DO#
Translist #
Notes
Amount
Date

Possible Transact
Translist# (KEY)
Name
Expected?


So those are my tables. Now I was creating blank forms and using basically
VBA to control all my date. I found I can create a form directly from my
table, and it can sort and add recrords to the table much nicer then I had
set up!

My problem is the reletonships, for example.

I add a job to the "job list" table. I need it to create a record in the
debts and owing table to accoutn for this job and I cant get it to do that. I
tried setting a reletonship and no luck!.

Any tips?

.