Search results

Thanks Neil, thanks for all your efforts. I can see where you are coming from. I did think to myself that I can purchase a PC from a number of suppliers, not just HP so supplier is probably the wrong naming convention (should have stuck with manufacturer!!) as this is what I meant!! In an...

Makes Sense Thanks Neil. I obviously have to have a relationship between tables, just wondered why ProductID is the preferred attribute in tblComputers and not SupplierID. I presume this is because you said SupplierID is an attribute of tblSupplierProducts and not tblComputers (although I...

Makes Sense Thanks Neil. I obviously have to have a relationship between tables, just wondered why ProductID is the preferred attribute in tblComputers and not SupplierID. I presume this is because you said SupplierID is an attribute of tblSupplierProducts and not tblComputers (although I...

Me Again Just so I am clear. I have table(s) that store information about all computers / hardware / software etc..on the network (tblComputers - tblHardware - tblSoftware). I will use tblComputers as my example here. To eliminate duplication I created additional tables to store information...

Makes Sense Neil you make perfect sense. I can remove SupplierID across multiple tables. The ProductID (PK) was an oversight. I have been playing about and did not set it up after re-naming the table + fields!! Many Thanks, Phil. PS: I have a more challenging problem regards how license...

Working Neil it is now working!! I have retained the SupplierID with tblComputers but have linked via ProductID. So why is this relationship required? I developed with the following in mind: tblSuppliers as the parent table tblSupplierProducts as the child. A Supplier (i.e. company that...

Re-Try Neil I will retry and post back. Many Thanks, Phil. PS: Access 2002-2003 format

Still a Problem I removed SupplierID from tblComputers. Linked tblComputers to tblSupplierProducts (ProductID). Same issue so back to where we were. Any ideas? Thanks, Phil.

Reply Thanks Neil. I will remove and test. I had a similar setup in the system that worked. Instead of tblSuppliers I had tblComputerMakes instead of tblSupplierProducts I had tblModels. tblComputers ComputerID PK ComputerMakeID FK ComputerModelID FK tblComputerMakes MakeID PK...

Another Thought In the past when I created qryENTRY_COMPUTERS then added tables tblSupplier & tblSupplierProducts relationships were automatically created between tblComputers - tblSupplier (SupplierID) and tblComputers - tblSupplierProducts (ProductID) SupplierID FK tblComputers ProductID FK...

Reply Thanks for the reply + link. I have had a look but nothing jumps out. Had a look at the query properties for both databases (one that works, one that doe not). The settings are the same. I belive the indexing to be OK.The Record Set Type is Dynaset. This works as stated previously by...

tblSupplier & tblSupplierProducts The issue is caused by the addition of tblSupplierProducts to any relationship within a query. I can happily relate tblComputers & tblSuppliers in a query. If I had tblSupplierProducts in order to capture the ProductDescription then it fails to work? Hope...

Anything Obvious? Guys can anyone see an obvious error regards what I have done? Really miffed? Thanks, Phil.

I made a number of changes to a DB that was working fine (normalised further). So what's wrong? I have a number of forms (for my sample DB I have stripped down to just one, if I can resolve for this I can apply to others). qryENTRY_COMPUTERS ENTRY COMPUTER FORM The user adds a new computer...

AssetID Any ideas out there regards best way to track Assets? tblAssetID: ID AssetID Type ID Supplier ID Product ID Date Purchased Example AssetID = A0001 TypeID = 1 (Desktop PC) SupplierID = 11 (Hewlett Packard) ProductID = 38 (dc7700p) Date Purchased = 01/01/2007 So the above table lists...

Calendar I have attached a sample DB (access 2002-2003). It opens to a form, hit Sales Analysis button, from the combo select criteria you wish to return data on then date range from the calendars. I did the DB a while ago. You should be able to modify to suit your requirements. Phil.

Sample DB I have attached a sample DB (access 2002-2003). Ignore all the stuff that does not work ( I have changed a fair bit but have not updated). So what to look at. tblAssetID and frmENTRY_ASSET_ID It would be good if I could link the asset to the equipment. i.e. If I looked at Computers...

Asset Id Hi Pat, it has been a while. I have been modifying other tables also. For instance I had: tblComputerMakes tblComputerModels tblHardware I used to store say Dell in both tblComputerMakes & tblHardware I normalized to have a tblSupplier + tblProducts (have also done this for RAM &...

I have decided to futher develop / normalize a db I have been working on for well over a year now (keep promising to post the updated version when complete!!). I currently have a number of tables that may or may not require an Asset ID. i.e. tblComputers tblSoftware tblHardware I have...

Copy Are you looking to copy the data from table A to table B? This goes against the grain but can be required in certain circumstances (i.e. remove data to a holding table). What is it you want to achieve? Phil.