Search results

Plog - i'm very sorry buddy but you're confusing me. I don't even have a table for Suppliers called tblSuppliers. wiklendt - thank you for your explanation, however the only reason I have created a link between fields that are identical is simply because one of the tables is the source of a...

SpikePL, thank you for the pointer. I will look those up. Plog, perhaps I have a misunderstanding on the paths. I was under the impression they were needed if I was going to create a lookup field using the contents of another table. It happens that where there is more than one path, those...

Hi Plog, i've already posted the most up to date relationships screenshot that I have, did you look at that? Also, I did mention in previous post that I had made all the changes I could, and have asked questions about other changes. Would you be kind enough to have a look at those for me...

Supplier isn't in tblMaterialsCategory. Supplier would only ever show up on one of our purchases which would be stored against tblMillCerts. tblMaterialDescription ended up being one field so I deleted the table and created a selection list within the tblMillCerts table instead. There is going...

OK, lots of rebuilding done. I think this is the direction I needed to take, got rid of a few tables, brought naming conventions in line and also make sense to the table contents. points of note as requested: tblMaterialsCategory is the base underlying information for all materials we receive...

Thanks for coming back so quickly. 1) Dare I presume that in tblMillCert I should have a SupplierID field which performs a lookup linked to tblSuppliers and that tblSuppliers should have a single field with unique names and this field should be its own PK? If so, I have already made this...

Good afternoon Plog, thank you for your input, very kind. A couple of things if you would. I spent a bit of time last night restructuring, and will again tonight look at the information again to take into account what you posted today. If you don't mind me asking a couple of questions...

I wonder if this screenshot will help show how the data flows together. Please note, I am already aware that there are two tables with the same data in for materialcategory and materialcategorynew. I am in the middle of testing an update to the products list and didn't want to muck up the...

Two extra fields on right hand side which automatically populate with the min and max values based on the chosen material on the main form, where the analysis field in the tblMaterialData matches the analysis field in the tblMaterialSetValue. Apologies I thought my explanation was at least...

Good evening all, I hope you can help i've literally pulled my hair out on this one. Please refer to the attached picture which is the best representation of how I want to use the database I have. I have a form (frmMaterials) based on the table (tblMaterials) with various linked tables and...

I can but that defeats the point of connecting to the ODBC and pulling a copy of the data directly into Access. I would rather not have extra steps inbetween... Rather than exporting as a csv file, I have set up access to import directly into tables that I can use with various forms and queries...

Hi and thank you for taking the time to respond. I have created a copy of the same database which runs from linked tables but sadly it is hideously slow at pulling data from Sage.

apologies for the bump, but has anyone got any advice for my two questions? Kindest regards

Good afternoon! I haven't often posted if at all, but after much searching and failing I thought it best to ask the experts. I am currently using Microsoft Access 2010 32bit, and have one database acting as parent, with a second linked database as a client for people to work with, and the...