M
Maria
Hi,
I've created a database to help organise a large collection of Symbol
files that contains the following fields
Table: Huvudtabell
Fields: ID (conter) (Primary key)
Namn (text)
Syfte (text)
Table: PDF-er
Fields: ID (long integer)
PDF (hyperlink)
InDesign (hyperlink)
Table: Bildoriginal
Fields: ID (long integer)
Bildfil (hyperlink)
I have created a form to add a new symbol and I've gotten as far as
adding a new row to the main table containing the Namn and Syfte that
the user entered in text fields in the form.
In the form I've also created a text field and a browse button. By
browsing for the wanted file I manged to view the link in the text
field but now I have a few problems that I'm not sure how to attack.
1. Add this text as a link into a new row in one of the sub tables
(let's start with Bildorigingal)
2. When imported the new row in the sub table should inherit the same
ID as was give to the new row in the main table.
3. I should be able to add a few different files that belongs to the
same symbol, meaning one row in the main table could referr to several
rows in the sub table, linked by the ID.
The data in the main table is added by a query. Would this be a good
way to add the links as well and do I create a new query or can I write
everything in the same query.
/Maria
I've created a database to help organise a large collection of Symbol
files that contains the following fields
Table: Huvudtabell
Fields: ID (conter) (Primary key)
Namn (text)
Syfte (text)
Table: PDF-er
Fields: ID (long integer)
PDF (hyperlink)
InDesign (hyperlink)
Table: Bildoriginal
Fields: ID (long integer)
Bildfil (hyperlink)
I have created a form to add a new symbol and I've gotten as far as
adding a new row to the main table containing the Namn and Syfte that
the user entered in text fields in the form.
In the form I've also created a text field and a browse button. By
browsing for the wanted file I manged to view the link in the text
field but now I have a few problems that I'm not sure how to attack.
1. Add this text as a link into a new row in one of the sub tables
(let's start with Bildorigingal)
2. When imported the new row in the sub table should inherit the same
ID as was give to the new row in the main table.
3. I should be able to add a few different files that belongs to the
same symbol, meaning one row in the main table could referr to several
rows in the sub table, linked by the ID.
The data in the main table is added by a query. Would this be a good
way to add the links as well and do I create a new query or can I write
everything in the same query.
/Maria