Les,
i am working on a database system where a number of tables (5-10) each
with possibly hundreds of columns share an identical primary key name.
the truth is if it weren't for a limitation in the number of columns in
M$ Access (long story: we're creating a client server scheme so they
Martijn Tonies wrote:
When creating the view, use
CREATE VIEW viewname ( column names )
AS
select [fields]
Instead of *. This way, you can only return a single mat column instead
of having that column twice in the view.
i'll try that programmatically, no way am i typing close to 1000 field
When creating the view, use
CREATE VIEW viewname ( column names )
AS
select [fields]
Instead of *. This way, you can only return a single mat column
instead
of having that column twice in the view.
i'll try that programmatically, no way am i typing close to 1000 field
names into
i am working on a database system where a number of tables (5-10) each
with possibly hundreds of columns share an identical primary key name.
the truth is if it weren't for a limitation in the number of columns in
M$ Access (long story: we're creating a client server scheme so they
can get