[FONT="]I am a MS Access novice, and am looking to develop an application based on Access 2007/10:[/FONT]
[FONT="]- It is meant for a government agency that is tasked with assessing clients needs for certain equipment.[/FONT]
[FONT="]- The agency sends an assessor to meet the client and produce a report highlighting the equipment the client requires.[/FONT]
[FONT="]- The equipment is divided into several groups according to type.[/FONT]
[FONT="]- Prior to purchasing the equipment for the client the agency is required to obtain 3 (or possibly) more quote from a list approved suppliers. [/FONT]
[FONT="]- The quotes are typically obtained from the suppliers' catalogues or over the phone/email.[/FONT]
[FONT="]- The equipment is then purchased within a week or so, so the quote from the supplier is essentially only valid for a week and needs to be kept for record-keeping only (not for future use).
[/FONT]
[FONT="]A diagram of the relationship between the different tables is attached. (the table tblAssEqptJoin holds the details of a quote from a supplier for a piece of equipment).[/FONT]
[FONT="]Before I continue I would be most grateful for any corrections/suggestions/etc from the wiser/more experienced members of the forum.[/FONT]
[FONT="]Many thanks in advance,[/FONT]
[FONT="]J.[/FONT]
[FONT="]- It is meant for a government agency that is tasked with assessing clients needs for certain equipment.[/FONT]
[FONT="]- The agency sends an assessor to meet the client and produce a report highlighting the equipment the client requires.[/FONT]
[FONT="]- The equipment is divided into several groups according to type.[/FONT]
[FONT="]- Prior to purchasing the equipment for the client the agency is required to obtain 3 (or possibly) more quote from a list approved suppliers. [/FONT]
[FONT="]- The quotes are typically obtained from the suppliers' catalogues or over the phone/email.[/FONT]
[FONT="]- The equipment is then purchased within a week or so, so the quote from the supplier is essentially only valid for a week and needs to be kept for record-keeping only (not for future use).
[/FONT]
[FONT="]A diagram of the relationship between the different tables is attached. (the table tblAssEqptJoin holds the details of a quote from a supplier for a piece of equipment).[/FONT]
[FONT="]Before I continue I would be most grateful for any corrections/suggestions/etc from the wiser/more experienced members of the forum.[/FONT]
[FONT="]Many thanks in advance,[/FONT]
[FONT="]J.[/FONT]