Search results

@mike60smart @The_Doc_Man @Pat Hartman @cheekybuddha Thank you all for the help. I still don't understand what I do not know therefore, I just don't get it...lol I realize my relationships were not correct, was that the only issue, or was it the fact that a query could not do what i was...

@The_Doc_Man @Pat Hartman Just not getting it…. What I do know is that in my list of vendors, one vendor can have multiple location(s) each location will have multiple contacts. The vendor “Table” displays the correct data in the correct relations. I just want to be able to add, remove...

Good morning and Happy New Year! I understand what you are saying however, I do not understand the structure of a "Hierarchical Relationship". I have made a couple of attempts to create the hierarchical relationship but once created, I still could not update the tables using a form. I am not...

Gotcha, neither am I... I'm looking for some kind of example on the web.

Okay, I understand. Would the proper method of accomplishing this be to add another table containing fields from the 3 tables, or a form (Vendors) with a subform datasheet (Vendor Contacts)? Thinking out loud...adding another table would create duplicate data, so maybe form/subfrm would be the...

I've created a query based on 3 related tables. The goal is to create a form based on the query to view and add records. I know my query is not correct because when I run the query, I can see the record however, I cannot add a record. Can someone explain the theory behind the query I am trying...

Let me chew on this for a bit. I follow, just not 100%

@The_Doc_Man I appreciate your time to review this. The fields Pax_1-Pax_6 are place holders for passengers. There are 6 seats available on each flight. While this may not be relevant to your statement concerning non-normalized table, I'm not sure how I would keep record of each passenger...

Trying to build a flight time tracking database. I’ve created the tables with all the info that is needed for the app, and set relationships the way I think they need to be. tbl_Flights : tbl_Leg (One to Many) A flight consist of 1 day. Each flight can have many legs. I’ve created a form based...

@KitaYama I've tried that multiple times. For some reason, dragging the handle down does not increment the bracketed number. Would not even give me the option to select "Fill Series". However, I was able to get what I needed from the post by @Gasman Thank you for the early morning reply...

@Gasman Thanks for the reply! I will add the starting row# to the formula and that should work! MNET_1.writedata section is way down on row 854. I have the readdata above the writedata. Cheers!

In a column, I have the following text. MNET_1.WriteData[1] I need to fill down to MNET_1.WriteData[960] Selecting and dragging down does not increase the bracketed number, nor does adding 1 to the previous cell. Not wanting to manually enter all the number, is there any way to accomplish this...

@Pat Hartman Following your example, I've put together a form that list the company, and the contact within the company selected. Works well but I have a question... Having only two tables, tblVenCompany, tblVenContact. What is the best approach to add a new company to the tblVenCompany? The...

@mike60smart Good morning Mike! I've downloaded a couple just to see some basic structure and they pretty much all look alike, same programming style. @isladogs Top of the morning sir! I still haven't gotten a change to get back into the AttentionSeek db. When I do, I will let you know...

@arnelgp Many thanks for the early morning reply! :coffee: I haven't even looked at the reports. Seems I have answered my own question....lol

I've downloaded the Contact Management Database template and was wondering about these two query statements. The first and second columns are expressions. File As: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " &...

The intention is to select from a combo box the company, then in a cascading combo box select the contact needed in relation to the company name from the company combo box. Text boxes under the contact combo box would populate with the selected contact. This would happen in an order form of...

Good morning Pat. Thanks for replying to this thread. I've taken a step back and reverted to pencil and paper to try and get the tables & relationships figured out. Synopsis: Two tables. tblVendorCompany, and tblVendorContact. Within some companies that I order materials from have different...

Forgive my frustration... I am trying to learn this as I go and want to do it correctly. This is not something I have to do, it's something I WANT to do. Again, sorry for my frustration. -Kyp

Wow... Any way to keep it simple?