Recent content by zyxwvu44

i think what you want is a continuous form, which will update as you fill it in if its linked to the table directly.

for the record source try: SELECT table.[ID], table.[name] FROM table ORDER BY [name];

try changing the bound column to 1 or 2

in the properties, set the first column width to 0, the second to 1", or however wide you want it. so, it will look like this: 0";1"

can the acess 2007 free version run on windows xp?

why not cascade delete on the relationship?

Try using one query. This might help: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=285 it writes the sql for your query based on your selections, you can then filter the fields afterwards.

I figured it out, had to set more indexes and rearrange my relationships, thanks

for the querying, what about something like this? http://allenbrowne.com/AppFindAsUType.html

I want to comment on a counterparty given a certain product. so, counterparty A and product X have a comment, counterparty B and product X have a comment, counterparty A and product Y have a comment, etc.

Hello again, I am trying to have users be able to see and enter comments on a form along with results from a query. My database looks like this: the "comments" table is what i'm having problems with. Right now i have a query where a user selects a product and any number of funds and it...

I have this table in the relationships, but i dont know how/what to link it to? I need it to match up with the details section of a form that comes up with Counterparty, given a product

Okay now i have another problem with my relationships, i need to add a comments column that is linked to a specific Counterparty(as a whole, not the entities) and a specific product. For example something like this: Counterparty A, Product A, "not preffered" Counterparty A, Product B, "Quick...

thanks keith, i think i got that working now

oops, the company is the counterparty. Each product can be traded in each fund, but only certain companies(counterparties) will do so, hence why i am making this database so i can easily look that up. Right now the combine table looks like this: Counterparty ID, Product ID, Fund ID, Avaiable...