G
Guest
I have 2 tables.
1. a list of contracts with a primary key of the bid number
2. a list of documents the a foreign key of the bid number. There is a
hyperlink field in this table to the newtwork location of the documents.
Ther is a one to many relationship for contract to document through the Bid
number key.
I have a form with a sub form that lists the documents associated with the
bid number. I would like to have a command button on the end of each line in
the subform that will open the document based on the hyperlink on that row of
the table. Therefore each row should have a command button that opens the
document for each line.
I have eevrything all set except the buttond for each line, I am sure it is
easy, but after working on this all day I am missing it.
Thanks for the help
1. a list of contracts with a primary key of the bid number
2. a list of documents the a foreign key of the bid number. There is a
hyperlink field in this table to the newtwork location of the documents.
Ther is a one to many relationship for contract to document through the Bid
number key.
I have a form with a sub form that lists the documents associated with the
bid number. I would like to have a command button on the end of each line in
the subform that will open the document based on the hyperlink on that row of
the table. Therefore each row should have a command button that opens the
document for each line.
I have eevrything all set except the buttond for each line, I am sure it is
easy, but after working on this all day I am missing it.
Thanks for the help