Referencing a record

[z178]

I am not sure if "Referencing" is the word for it.

But I have a database for my research notes.

I have some notes (Lets say under topic A) repeated exactly the same way elsewhere. rather than re-entering the same question in the context of a different topic (Topic :, can I use a checkbox which if checked will create a reference from the current record to another record within the database.

Would this be a situation to use lookups?

[Søren Dyhr]

Would this be a situation to use lookups?

Hardly the most efficient storage, lookups are only valid as choise, if you need a snapshot of say the pricelevel at a certain historic moment. The urge with relational designs, on the other hsnd is t prevent redundant storage, so event if you think the job at hand requires a carbon copy should it structurally instead be solved in a way where the same record show up REFERENCED where it's required.

There is some templates ... I think you need to search on the term survey perhaps this one:

http://www.fmforums.com/forum/attachment.php?attid/9694/

--sd

[Charmaine]

can I use a checkbox which if checked will create a reference from the current record to another record within the database.

Yes. Just make the checkbox field the key field for a relationship to a table where your notes are stored.