Re: [MSAccessProfessionals] Access 2006 Simple question

Hi,

 

Probably by having a foreign key relationship in the relations form with either tables of table/query relationships perhaps.

Hope this helps.

Rob

 

Van: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> Namens cash.ghwa@gmail.com
Verzonden: zaterdag 27 maart 2021 23:14
Aan: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Onderwerp: [MSAccessProfessionals] Access 2006 Simple question

 

Hi.

 

Seems the only time I ask a question is when I have a senior moment.   I wrote a basic query years ago.. When I get my results, I somehow connected the result records back to the main database. They can be displayed by clicking on the "+" that shows up to the left of the record.  How did I do that? I tried creating a new query but can not get it.  The original one has the query "related" to the main database by the "Itemnbr ".

 

The main database (stripped down version) contains: itemnbr, description, cost, sell, purchasedate, selldate.  Nothing fancy.  The query table only contains: itemnbr, selldate.  When I run the query I can click on the result record by using the "+" to recall more details about the item if needed.

 

Simple!!   Not anymore…… HELP!

 

I have another senior moment issue, but can wait on than one….I'll try figuring it out for a bit longer before I give up.

 

Thank you.

 

Carol Higbee

 

 

Sent from Mail for Windows 10