Search results

Thank you very much. Do you know that I had created another table while testing this and included a division_selected field. Ok, I got the continuous form showing what I need thus far. Now to make it function, lol. I will be back. Thank you so much again!

I would like to open a form to display the contents of a table. The table is like this PK = DivisionID DivisionID DivisionName 1000 General Conditions 2000 Site Work 3000 Concrete I would like to be able to display...

Hi, I don't want to keep annoying you, but I have something else I need clarity on. In my table tblJobInfo, where JobNumber is the PK field, is it good practice to have alot of foreign keys in this table? As far as I can phathom they aren't out of place but it just leaves a whole lot coming...

I didn't actually run into a problem yet, but I didn't want to go any further if my relationship was wrong. So it is ok to link a PK in one table to Fk's in one or more tables? I haven't done access in a lonnnng time, and it just didn't look right to me.

Is there something wrong with this question? I'm not having any replies!? Can someone assist me please or tell me what to do in order to explain the question better if it is confusing everyone?!?!

Hi, I am creating a new database to store information on Jobs. The criteria are; A Job has a Job # and a Job Name When allocating jobs, the job is broken down into Divisions. Each job has many Divisions e.g. Job_Number: 101 Job Name: Remodel the Kitchen Divisions: Carpenters, Plumers, Tilers...

I'm with you all the way with the combo box method. Totally works for that part. I guess I have to explain the spiders web part of this to highlight the problem further..... So I create a combo box to lookup CertificateHolder names in tblInsuranceInfo.CerticateHolder, if they don't exist (Not...

It only allows 1 autonumber per table, theres my answer. Ok, so back to the subform method. Any ideas where to go with this?

Hey. Let us review .... your tables are set up like .... tblJobInfo ---------- JobInfoID InsuranceID JobName tblInsuranceInfo --------------- InsuranceID CertificateHolder AdditionallyInsured All of the above is accurate. But I'm not trying to click on anything. I do understand where...

I have a table tblJobInfo with a field in it called InsuranceID. This is not the KeyField, but it is related to another table tblInsuranceInfo who's keyfield is InsuranceID. The two other fields are related elsewhere and it is a kind of spiders web, but once I have the answer to this, the rest...

Thanks for your help, totally appreciated. I have to stop thinking outside the box and get the function working primarily like you suggest.

So create another table so that I have 2 tables that will look like this: tblCompanyInfo : CompanyID, CompanyNameID tblCompanyNames: CompanyNameID, CompanyName And the display method you suggest would certainly work, but I was curious was there a 'fancier' way of doing this, like the idea I...

I have a table (tblCompanyInfo) with the following Fields: CompanyID CompanyName I want to create a form where I can add Company Names to the table. Easy, yes I know. On the form I want to be able to display 1 text box for input of the Company Name but with the option of adding more than...