I actually raised this question because I'm at odds with the design. Thanks for the sanity check :)

Using an account view is a good idea. Thank you!

Hi, I have a design question that I was hoping a professional could answer. Lets say I have the following one-to-many table relationship between an Account and its Addresses.

create table account (
acctkey int,
acctname varchar(100),
active bit
)

create table acctaddress (
acctkey int,
addkey int,
street1 varchar(100),
isprimary bit
)

An account can have many addresses but only one can be the primary. Does it make sense to include a soft link in the main table to hold the key of the address that is the primary? ie.

create table account (
acctkey int,
acctname varchar(100),
active bit,
primaryaddkey int <---
)

This is purely to return the primary address of account (with the best performance in mind). Is this a bad design? Does the need to sync the account and acctaddress tables outweigh the performance advantages? I would appreciate any thoughts on this. Thanks Ryan

Hmmm add another textbox?

I'm loving the dark colour theme

There was a time when people thought that it was impossible to cross the Atlantic ocean because a ship would need more coal than it could carry.

Tremors starring Kevin Bacon

Amusing story :) I enjoyed that.

Ahh I bet the old fogeys in your day were ridiculing you for liking AC/DC.

Despite your efforts, at the end of the day it's your fence so it's your responsibility.

I kinda feel sorry for wordy... he's just trying to help you out

You're getting married? I can recommend a ring... suffering

:laugh: that's funny. That reminds me of the time my web page kept returning an error when I was trying to view a text file. That is until I realised, the file contained text of a web page error. It must have been a Monday.

saxenaabhi6 wrote:

(not a part of our job)

You said it's not part of your job, but would you be working on the job during work hours? If not then you should consider negotiating with him a freelance rate since you will be doing this on your own time (albeit with a discount since he is your boss) I understand he is your boss and all, so it's a sticky situation but you should make it worth your time.

Hmmm how odd. If I vote a 3, why is it deemed any less relevant just because it doesn't follow the majority?

It's extemely accurate too, I just uploaded a picture of myself and it returned images of models.

Err yeah thats exactly what I meant. I didn't claim to discover it myself.

Just discovered today that if you continuously click on the first link of any Wikipedia article (that is not in brackets or italicised) it will eventually lead you to the topic on Philosophy.

GAMerritt wrote:

Undocumerited

I see what you did there

1. Check with your bank if they offer an sms service that notifies you if a deposit has been made over a certain amount. 2. Sell a kidney