Relatonships between forms!

Kavy

Well-known Member
Joined
Jun 25, 2007
Messages
607
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 data. 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?


Thanks again for anything!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

huh?

Board Regular
Joined
Aug 3, 2004
Messages
72
See <a href="http://www.mrexcel.com/forum/showthread.php?t=321738&highlight=create+form+modify+table+time+work">here</a> and see <a href="http://www.mrexcel.com/forum/showthread.php?t=323671&highlight=create+form+modify+table+time+work">here</a>.

Hope this helps.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,371
Messages
5,595,784
Members
414,020
Latest member
Meghdad

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top