The correct way is close to the first way.

tlkpStateCode

StateID int (Identity) (pk)

StateCode varchar(10)

CountryCode varchar(2) (Using ISO 2 character standard) (FK tlkpCountry)

StateFullName varchar(50)

Unique index on StateCode + CountryCode

This design will allow...

I pointed him to the CHARINDEX and SUBSTRING functions.

CHARINDEX allows him to find the starting character number of a character or string inside of a string.

SUBSTRING allows for the parsing...

He is talking about Access Data Project...

First, a user should never, not for any reason, have access to or be entering data into a table directly.  Design forms and do...

After you correct the Bit datatype issue, delete all of the linked tables and link them again.  Just relinking them does not refresh the information Access stores about the linked...

And, a totally different idea...

Create a table that has all the date conversions done, a dimension table.  Then simply link to the table and pull only the month converted to...

With that specific design, you will need a separate resolver table for each type of party (employee, supplier, customer)

tbl_EmployeeAddress

EmployeeAddressID (pk)

EmployeeID

AddressID

AddressType

would be an example of the Employee Address table

Send me the first 200 characters with about 10 records and I will send you the code to do the parsing.  rl_stewart@highstream.net

That is why I said short.  🙂  Based on the business logic for what he needs to do, you may or may not need audit, status, and effectivity columns included.

I agree with all of the others. 

Bad design is bad design.

Sure, you can build it any way you want to.  But, there is a price to pay for doing...

Here is a short normalized version of what you need to do:

tblParty

PartyID (PK)

PartyName

tblAddress

AddressID (pk)

AddressLine1

AddressLine

PostalCode

CityName

StateCode

tlkpAddressType

AddressTypeCode (pk)

AddressTypeDesc

tblPartyAddressType

PartyAddressTypeCode (pk)

PartyID

AddressID

AddressTypeCode

Actually, the best thing to do is make the adjustment in Access.  Since the HTML code can occur any where in the text, you will have to write a rather...

That is what one-to-one relationships are for.  🙂  Just break your migration into multiple tables and then use views to combine them back together.

controlname.requery is the syntax for getting the combobox to requery and grab the new data.

A trigger is not the way of doing what you are wanting to do.  The trigger...

You might want to look into using BizTalk for this.  It is designed to automate business processes through messaging.  I think you could automate the process without it, but it...

Are you moving all 45 million rows each night?

If so, what you want to try is creating one or mor text files from Oracle and then using the bulk load...