Cfoutput query and form field names

[College_Kid]

I have a form that have two field inputs. I would like to repeat the form fields as part of a cfoutput query. The first field of the form automatically populates the different person's name (via cfoutput query) and this form field is called "tenant". The next field of the form is called "sales". The sales field is left open for user imput. The entire form is in between the cfoutput query tags. When the cfoutput query is executed, Both form fields of the form is displayed with each tenant name listed in each of the first form fields of each row. The problem I'm running into is that even though the form elements appear to display correctly, I would like the name of each of my form elements in the cfoutput query, of each row to have a different form field name like, tenant2, sales2, tenant3, sales3 etc. is that possible?

Here's what my code look like.

<cfform action= "addsales.cfm" method="post">

<cfoutput query="tenantsales"><Input name="tenant" type="text" value="#office.tenant#" size="32" />

<select name="sales"><option>$5</option><option>$10</option><option>$12</option></br></cfoutput>

<input name="submit" type="submit" />

</cfform>

[Dan_Bracuk]

If your query includes a tenantId, use that.  <input name="tenant#tenantId#" etc.

If not, use the currentrow variable from the cfoutput tag.

[College_Kid]

Thank you for the information that is exactly what i was looking for. I ended up using the tenant#tenantId#  and it work like a charm. Now i would like to be able to pass the form field variable the same way. However I'm having some difficulties when i do the following:

<cfquery name="AddSales" datasource="master">

INSERT INTO sales (salid,

saltenant,

salsales)

VALUES ('00',

'#form.tenant#',

'#form.sales#');

The form field values are not passing to my action page.

[Dan_Bracuk]

You'll have to use array notation:

form["static part" & variable part]

[BKBK]

I cannot imagine why you would want to show a list of pre-populated input fields. What makes sense to me is a select-box. If that is indeed what you want, then you could do something like this:

<cfform action= "addsales.cfm" method="post">

<cfselect name="tenant">

    <option value="">Tenant</option>

<cfoutput query="tenantsales">

    <option value="#tenantsales.tenantID#">#tenantsales.tenantName#</option>

</cfoutput>

</cfselect></br>

<cfselect name="sales">

<option value="">Sales</option>

<option value="5">$5</option>

<option value="10">$10</option>

<option value="12">$12</option>

</cfselect></br>

<cfinput name="submit" type="submit" value="Submit" />

</cfform>

Like Dan, I have assumed your database table has a column for tenant ID.