R
Roberto
Hello,
I have a table that contains a project name for each record. These projects
can generate one or more publications. However, if I put them on the same
table and record, it is hard to query them and count the number of
publications by type or by status.
I was wondering if it is possible to create a table with only the project
name and then another table that contains the different publications for each
project name. I am not sure table relationships work for this.
For example, my current table has the fields: project name, pub1, pub1_type,
pub1_status, pub2, pub2_type, etc. Is it possible to move the publication
information into another table and link them to a single project name record
in another table even though the publications may be more than one record?
Hopefully this is clear. Help please!
Roberto
I have a table that contains a project name for each record. These projects
can generate one or more publications. However, if I put them on the same
table and record, it is hard to query them and count the number of
publications by type or by status.
I was wondering if it is possible to create a table with only the project
name and then another table that contains the different publications for each
project name. I am not sure table relationships work for this.
For example, my current table has the fields: project name, pub1, pub1_type,
pub1_status, pub2, pub2_type, etc. Is it possible to move the publication
information into another table and link them to a single project name record
in another table even though the publications may be more than one record?
Hopefully this is clear. Help please!
Roberto