Using table temporarily for code snipz

[Cameroncha]

i am trying to build a non editable query with multiple tables combined. . . i have 1to1 and 1tomany tables successfully combined.

I have a seperate table with no relationship to the others that i hold "code snipz" (htm code and javascript snipz) that i would like to place in each row of the query with all of the records.

As soon as a add the table with the snipz in it i no longer get any records returned into the query.

is there another way to approach this.... is this even possible.

 

[The_Doc_Man]

As in, html and javascript formatting?

If you are in AC2K, you can do some pretty formatting things for ASPs (pages). In AC97, not sure how to approach this. But including code as part of the query is probably not the way to do it. Access won't interpret the html or java because it isn't designed to do that.

As to the query returning no records, I think we would need to see the query in SQL and some data samples from the involved tables. The fact that there is no relationship between your other tables and your Snip table worries me, because if you try to join with it, you run a severe risk of getting what is called a permutation or geometric join. Trust me, you really don't want that to happen.

 

[Cameroncha]

i am using 2k.... it is not for an asp page but that is what i am working this database towards (any good resources ?)

For now however, i am trying to sandwich data with the snip table
(which only has 1 row)

I guess i should make another table, link each single column from the snip table as a default value for a new table with a key of lets say sku i have attached what my current relationships look like.

Thanks for your help.... if it weren't for people like you i would never learn.