Recent content by DStevens

Yeah I changed that awhile back but ended up nuking my code and takinga different route. I just formatted the tips in the loop via if statement comparing the field name. I cannot figure out how to get query = "SELECT ITEMS." & col & " FROM ITEMS WHERE (((ITEMS.ITEM_NAME)='" & item & "'))"...

Yes but it gives me an "Item not found in this collection." error on the [MyList = MyList & ";" & record!col] code. To the best of my knowledge, this error means the field was not found. I could more than likely be wrong though. Here's what the table looks like: ITEM_ID | ITEM_NAME |...

Hey all! I have a dilema: I'm essentially building a tooltip for an object based on data found in a table. I have the following function to query for the data: Public Function getItemTip(ByRef col As String, ByVal item As String) Dim query As String query = "SELECT ITEMS." & col & "...

Nope. They are raw data that need to be stored. Some calculations will be based off of them. I didn't think we'd want the sets in the same table since they aren't related to each other at all. Also, I forgot to add the FK to the set tables. Assume the PERSON_ID FK has the same value as the...

I'll give an example: PERSON ---------------------------------------------- PERSON_ID FIRST_NAME LAST_NAME 1 Devin Stevens 2 Jim Bob NUMBER_SET ---------------------------------------------- NUMBER_SET_ID MAX EACH PARTIAL 1...

SELECT PERSON.CPERSON_ID, PERSON.PERSON_NAME, NUMBER_SET.NUM1, NUMBER_SET.NUM2, NUMBER_SET.NUM3, ANOTHER_SET.VAL1, ANOTHER_SET.VAL2, ANOTHER_SET.VAL3 FROM (PERSON INNER JOIN NUMBER_SET ON PERSON.PERSON_ID = NUMBER_SET.PERSON_ID) INNER JOIN ANOTHER_SET ON PERSON.PERSON_ID = ANOTHER_SET.PERSON_ID...

Hmmm, I guess I'm severely confused. Each of the "Num" fields are different columns representing similar but different things. How can I have 3 columns referenced in 1 column in the PERSON table?

I have 3 tables: PERSON ---------------------------------------- PK PERSON_ID AutoNumber FIRST_NAME Text LAST_NAME Text NUMBER_SET ---------------------------------------- PK NUMBER_SET_ID AutoNumber FK PERSON_ID Number...

K, I'm kind of hung up so I want to see if I'm doing this correctly. PERSON PK A_PERSON_ID AutoNumber FIRST_NAME Text SECOND_NAME Text NUMBERSET PK NUMBER_SET_ID AutoNumber FK A_NAME_ID Number NUMBER_1 Integer NUMBER_2...

Yeah brain fart. Forgot I could create a form to do the lookups and input data for me. Keep thinking I have to enter all data in the tables...

Noted. I think I've got the Database all separated out. Just gotta write queries to move the data to the new tables. I would like to show real table names and such but I don't know if I'm allowed to. Sensitive info :( I truly appreciate everyone's help! I may be back in the next few hours if I...

Funny, I actually had just read that before you posted it ;P

Haha apparently I'm terrible at my pseudocode! The rows do have a Primary key auto number for the ID. I'm not sure what you mean by putting the other numbers in a table. Why would I do that? I guess it just doesn't make sense to me having a table of names referencing a table of numbers with the...

The naming of the tables and columns are pseudo-code. I completely forgot about columns that share the max value. I'm going to have to rethink my strategy I think... Thanks for the reply!

Confusing question? The only way I can explain it best is to show it: Table1 --------------------------- Name Num1 Num2 Num3 Devin 224 18 845 Scott 322 32 652 Jim 179 46 929 Tim 202 41 562 Query Getting Max Value --------------------------- Num1...