Need help with this, please!

[Theshowstealer]

Ok i thought this is a very nice forum to come to, to ask this, i hope i have a good answer.

Ok i am doing a database in school for A level, and i am having problems with relationships. I aint the best at explaining so here is some pics with a little info.

I am trying to link both film titles from both tables.

I want to link these too tables so the names will come next to the number of the film.

When i try and do it this way, that help message comes up and unsure what it meens.

Here i have linked the ID number to the copy id number, and it shows what copies are there. And when i add more copies in this table, i want the name to appear in this table.

Any help on how to get the id number to interact with the name so they appear in the upper table would be great.

Hope this is an ok explaination.

Thanks in advance.

 

[llkhoutx]

Put field FilmID in table [Film copies].

Avoid using blanks in names. It will complicated four VBA coding when you get that far.

 

[Theshowstealer]

I don't understand what you meen to be honest, i've done what you said and it's still the same.

Any one else know about this unique number?

 

[ecniv]

Put field FilmID in table [Film copies].

Avoid using blanks in names. It will complicated four VBA coding when you get that far.

Is correct...



Your second table then has the following fields:
CopyID - auto - pk
FilmID - number
FilmCopyNumber - number
IsHired - y/n
AdditionanlNotes - memo/text

You then link the top table to this table via the filmID. Ergo - a relationship.


Vince

 

[llkhoutx]

Change the FilmCopy field name to FilmID, also MemberNumber to CustomerID.

CopyID is correct.

Except for junction tables (beyond our present scope), each table should have a primarykey which is unique for each record. To create it, select the field in the table design view and click the Key in the toolbar.

Fields are not automatically filled in linked tables, only when used correctly in related forms when linked properly linked. That is, directly creating an entry in one table does not cause a related record to be created in a related table.

A form, bound to a table, and having a subform, bound to a table related to the form's table, will create a record in the subform when data is entered in the subform. If the form and subform are linked properly, the linking field will be automatically filled.

The relationship view merely graphically shows the relationships, if any, between tables.