Can't get thru the basic step..

[calvinle]

Hi,

I have been trying and trying, but I can't get thru the basic first step for creating tables and it's relation. I read thru the book as well, but it doesn't help me either.

Here is what I will need, so if someone can help or guide me, that will be helpful:

1/ A list of member_id with first name and last name. I am able to do this, so I set primary key for the member_id for tbl_1.

2/ Each member_id is allow to choose many product. In the tbl_2, i have add "member_id", and "product_id". The primary should be "product_id"??

3/ Each product that was chose by the member, can have different fund with an allocation, so I have another tbl_3, which have "member_id", "product_id", "fund_id" and "allocation", but I cant get thru the primary id again.

4/ Each member then can choose multiple beneficiary, up to 10. In this case, I create another tbl_4 for beneficiary. I have in this table "member_id", "beneficiary??". How can I make that it can show each of the beneficiary with a last name and first name?

Thanks

 

[jdraw]

Readers have no context for your post. What re you trying to do? What book?
I strongly recommend you work through this tutorial from RogersAccessLibrary.

You have to work through the tutorial but you will learn about tables, fields and relationships.
Good luck.

 

[calvinle]

I have to create a registration form for a school project.

 

[jdraw]

Did you work through the tutorial as suggested?
That's how you'll learn.
Here's a second tutorial, but you have to work through it also.

Here are the steps involved in design -- from Barry Williams' site.

 

[calvinle]

Sure,

I will go thru the tutorial and come back if I have any question.

Thanks for the links.

 

[JLCantara]

Here is a mini tutorial. I did it because there are flaws in your description that needs to be specified. Unfortunately its Word365: hope you can read it...

 

[calvinle]

Hey,

Thanks so much for the help! I read through the Roger data file, and even yours, but maybe I can't get the part of the relationship vs the result that should be seen on the table?

Maybe the way I think access work is totally wrong?

Here is what I want as result. I have tried in many way, but it doesnt just give the right result that I wanna see, unless I am wrong since the beginning.

View attachment Registration.zip

In my attachment, I can't add new fund with example 90 because it says that it's missing a primary key null..

The way I see this is like, from the tbl_member, I can just add a member_id, then it will show the extended sign (+), then I then can add product_id, then add the fund and allocation.

The result will show in a final table as follow example:

V900 | DCPP | TYY | 90
V900 | DCPP | YHU | 10

The beneficiary does not exist yet as I am already stuck with the fund.

P.S. I have made a mistake for the beneficiary as the member is allowed to name up to 10 beneficiary for each product, and not for each member.

Thanks.

 

[JLCantara]

It doesn't work because your db design is wrong. I only have 40 years experience in programming so I might be wrong. Nonetheless, I recommend that you go back to my schema AND READ CAREFULLY the explanations of each step.

Since I see no form for data manipulation, I am afraid your leaving Charybde for Zcylla: good luck!!!