Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Intersection between a table of codes and a mystery tabl
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00187443
Message ID:
00187483
Views:
22
Does this mean I can have two intersect tables that reference the same table of codes?
create table AA ( cAaID c(6) primary key, ...useful data about AA records.. )
create table VG ( cVgID c(6) primary key, cVgDsc c(40) )
create table AG ( cAgID c(6) primary key, cAgVgID c(6) references VG, cAgAaID c(6) references AA  )

create table BB ( cBbID c(6) primary key )
create table BG ( cBgID c(6) primary key, cBgVgID c(6) references VG, cBgAaID c(6) references BB )

http://www.personnelware.com/samples/vintsec2.gif



Are there any gotchas using the same UI for many tables? or should I subclass?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform