Search results

Hey guys- I have 2 tables I am working with. The first one is the raw data I am importing (tbImport)- it includes records that are NEW, as well as records that are existing in the 2nd table. Some of the existing records will have updated info in this table, and will need the corresponding...

ok- so here's what I have... A flat file coming in with 3 fields in it- Agent1, Agent2, and Agent3. IF there is an agent occupying any of those positions, their employee code occupies that specific field. I have a junction table that holds the PropertyID (MLS) and AgentCode, as well as the...

Actually- Just figured it out. It's 2 problems at once. For some reason, it doesn't like the software's main DBF file. So, I export the records into a new DBF file. The software forces an ALLCAPS.DBF naming convention- which, the Jet Engine doesn't like. So, I rename the file and either link or...

ok- working on a sample db for you- my raw data is being a major PITA right now. So, I'm trying to figure out how to get it in here... Well- the other data I am bringing in with each file is hte Agent's phone numbers, fax number, email, office code, office numbers, office fax, office name, etc...

Yes, but not in Access. They are added at various times in a different software package.

I have a software package that uses a DBF file. I am linking to that file in Access 2002. Most of the fields are fine- however- at some point some of the field sizes are cut short. A text field that should have a size of 255 comes in as being a size of 44. This causes weird results in my data-...

ok- here is what I have now. I am getting really confused with how to write the update query for the Realtor's Information & Position- since it's happening in 3 different queries, and spawning across 4 tables. Here's my guess- I update the tbAgentOffice info, tbAgent info, and the...

ok- So I just realized that a Realtor CAN hold 2 positions at the same time in one record. So- if that's the case, I assume I need to take away the compound key, right? So what would the key be in the Junction Table?

The Table1 is actually a linked table from another application- I don't want to change that table at all- just copy the info out of it into MY table (Table2). From there, I manipulate the data, then normalize and split it up into about 8 different tables (about a level 4 normalization)...

Hey guys- I have 2 identical tables. I want to update the data from Table1 to go into Table2. Each table has well over 70+ fields in them. Instead of handwriting out each [Table].[Field] in either SQL or the Designer- is there a shortcut to tell Access to grab all the fields from Table1 and...

Thanks a ton!!!!

OR... would you just throw a Position field in the junction table and be done with it? That almost seems like the way to go- not a separate position table- but just a position field in the Junction table. Right?

ok- just re-read your response. So, 3 Queries- 1 for each of the positions. If Position 2 isn't null, then append the AgentCode into the Positions table, and mark the position field as '2' (or whatever). Same thing on the other 2 queries. Right? So- do I include the position number in the...

OKAY! So- what I am reading is this- I take out Agent1Code, Agent2Code and Agent3Code from the Property Table. I put in a 'PositionCode' into the Junction table, as a FK to the 'AgentPosition Table' with a 1 to Many relationship between it and the Junction table. I then run 3 separate queries...

Here's what's not making sense to me. The import file that I get the data from has all this info in 1 table. I then will be inserting the info into each appropriate table. So- the import file has a field for the Agent1Code, Agent2Code and BuyerAgentCode. When I update query that info into the...

Here's a pic of what my current Relationship table looks like... NOTE- the MLS is the PropertyID field- and that is linked tot he tbListings table if you scroll up in the table you can see it (just not shown here). The Agent1Code, Agent2Code and BuyerAgentCode are the 3 different...

OR would I have a separate table for the 3 positions- and make THAT a junction table between the Agent Table and the Property Table, with both FKs set as a PK in that Junction Table?

huh. ok- so then the coinciding position field would go in the Property Table? So I'd have 1 field for AgentCode, and AgentPosition in the property table? I'd also have a AgentPosition field in the Junction Table? Is that right? Then I'd establish another relationship from the...

ok... I can see where you're going with that- but... Let's say I query to find out which Agents are associated with which property. How do I tell which agent holds which position on the property (Lead Agent, Co-Lead Agent, and Buyer's Agent)? I assume if I just query the PropertyID and the...

Well shoot- this doesn't solve the problem tho. So I have 3 fields in the property Table- Agent1, Agent2, and Agent3. Each a different position in the record. I have the Junction table setup- but- how do I associate each agent's position to the Junction Table?