So now adding and editing inspections and equipment is working however still can't requery frmEquipment after new equipment is added
So now adding and editing inspections and equipment is working however still can't requery frmEquipment after new equipment is added
I know this is not what you wanted however this main form is used as a menu albeit with code it now adds the inspections in new (add) or edit mode and then you can open equipment in add or edit mode
I will start working on your form now
Thanks
Attachment 4836
How do you Edit Cities from this Menu.
Or equipment or Clients etc. How do you change a Clien't Contact's Phone Number?
My suugestions need a proper Menu. If you need to use the Current form then my suggestion is wrong.
PS With my Menu, the other forms will be created eventually. I am not suggesting that ALL of what you have done is wrong. You just have a difficult way of getting there.
Yes you are correct there is not a way to edit everything from main form however everything can be edited somewhere in database. I have not produced a comprehensive menu yet as I was trying to get the difficult stuff done
I am working on it now
Thanks
Attachment 4838
OK I have done exactly as instructed new form frmMenu has the menu command options that open the forms with the combos and only code is not in list (only for cmbStates in frmCities2 at this stage)
Thanks
Whan I said..........
Create the Following Forms. Sities, Cities, States, Clients and Contacts.
I was thinking that you would include all the Fields from the Table.
Hi Rain sorry for delay hope you had a good weekend
Apologies if I do not entirely understand what you are asking for, is the attached what you were inferring?
I have made the forms and the menu and queried tables for input, I have also now included all the fields for each table to the forms (clients is notable difference as not sure what you want with this one)
Not sure if I understand however either way I do agree I need a better menu for adding/ editing
Thanks
Attachment 4861
Think of it this way.
Just for now forget about the equipment.
Simply create a Form/Forms for the purpose of recording all the information about your Clients. (You will also need a Form for Contacts, Cities and States.)
This includes, all the Site and Contact information.
From the Contact Form use Combo boxes to select the Client, Site and City.
From the Site Form use Combo boxes to select the Client, Site and City.
You will need to use "Not on List"
Is this a problem?
The next problem will be to handle Multiple Sites and Contacts. But do the other first.
OK not doing anything with Equipment I created the four forms and think I have included all relevant info.
Simply create a Form/Forms for the purpose of recording all the information about your Clients. (You will also need a Form for Contacts, Cities and States.) This has been done, but confused
From the Contact Form use Combo boxes to select the Client, Site and City. Again this has been done however have not used cascading combos
You will need to use "Not on List" Trying to work out what you mean by this I have Not In list code in states combo in frmCities2, is this what you mean or maybe if notinlist then it opens another form to enter new rather than just doing it for the combo?
Attachment 4863
Which Form is the new one for Clients?
frmClients2
This is where I am most confused I just have 3 combos one for clients, one for sites and one for contacts
Only thing I can assume is that you select client, combo and sites, If either is not in list than you add another, either like in cmbStates as discussed or by opening the relevant form ie frmContact2 or frmSites2
Is this correct or am I not understanding where you are going with this?
Thanks
Your Client Form does not have ALL the information, (as per the Table)
Have a look at the Sites form that I fixed.
so I should have all site and contact fields on the client form?
I can see that you changed the query to take the primary key from the relationship above and therefore used CityID foreign key from tblSites and not from tblCity and the same you used StateID foreign key from tblCities and not from tblStates and then you just selected all other fields from tables
How do I deal with junction tables with a query like this? I have changed the compound key to a junction key, and added everything to the query like you did however as CityID is in tblContact and tblSites I added it twice
Not sure what other fields you want on form
Thanks
Attachment 4865
I can count 2 Fields in tblClients.
You have 5 in your Form.
How can I explain this better.
OK I am a little confused I have included ClientID if that is all it was missing
Clients (Clients will have a Dropdown box for Contacts) Contacts
Yes there is a drop down for contact
This includes, all the Site and Contact information.
All site and contact info was included as well as Cities/ States as this is part of Contacts... Do you want 1 combo as first statement implies or every field as 2nd statement implies?
Thanks