Schultz’s PowerBuilder Notes

Data Model


This is the data model and data for examples.

MODEL Table

MODEL_ID  int
MODEL_NM  Varchar(35)

Data
1    Fusion
2    Contour
3    Model T

COLOR Table

COLOR_ID  int
COLOR_NM  Varchar(32)

Data
1    Black
2    Blue
3    Dark Blue
4    Gold
5    Gray
6    Green
7    Red
8    Silver
9    White

MODEL_COLOR_XREF Table

MODEL_ID  int
COLOR_ID  int

Data
1    1
1    2
1    5
1    6
1    7
1    8
1    9
2    1
2    2
2    4
2    6
2    7
2    8
2    9
3    1

Advertisements

November 16, 2008 - Posted by | Drop Down Data Window (DDDW)

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: