Linking Records in a Form

[Gregbert]

Hello,

I tried searching for this and found nothing. I am not even sure it can be done.

I am wondering if there is a way to link one record to another on a Form? The database I built and managed for years is a very simple database to manage my DVD collection. I know very little about Access apart from what I taught myself. Within my collection which is catalogued on this database, I have recordings which are very similar and I would like to be able to have a link or something that I could click on to take me to that other record. If that makes sense at all.

All my record information is based in 1 table. The form itself displays all the information in an eye pleasing (to me at least) manner. If I have 1 record that is the main program and the other which is the rough cut or raw studio footage of that program, I don't want them on the same record but possibly something I could do a hyperlink or button or something to get to that other record with one click.

Is something along those lines even remotely possible?

Thank you for reading this!

Greg

 

[Steve R.]

The records on a form are "linked" by the data source for your form. So as you scroll though your record set with your form you go from one record to the next. You may be asking the wrong question. In a relational database, the records of different tables are linked by establishing relationships.

In re-reading your post, the answer lies in creating several tables that are linked to each other. You will need to read-up on normalization. Also do a search on DVD, CD, and Book Collection database templates.

All my record information is based in 1 table. The form itself displays all the information in an eye pleasing (to me at least) manner. If I have 1 record that is the main program and the other which is the rough cut or raw studio footage of that program, I don't want them on the same record but possibly something I could do a hyperlink or button or something to get to that other record with one click.