Recent content by milehighfreak

Easy; create a seperate table for the publishable and non-publishable fax numbers, link them to the people, and index the numbers and people in each table with no duplicates. Create a many-to-many relationship for people-to-numbers, and one-to-one for the fax tables. Even easier, include the...

You shouldn't be directly editing the junction table at all. Edit whichever you make the sub-form from within the table, and as long as the junction fields are present, they will autofill.

I'm not going to have any choice but to used linked subforms and a form for entering the data, am I?

Forms aint so bad. Use datasheet view, there's practically no difference.

That isn't really necessary, do exactly what I told you and your problem will be solved. You'll figure it out by the time you do it. You must create a form before you can manipulate a form, if that's your problem.

In the form design view, click on the grey area and select properties; under "Data" set "Add New Records" to no. You can also set that form property from within VB, the same way you set any object property. Edit: That property will apply whether the form is viewed as a datasheet or form.

Far better. Base your report on a query and it will be forced to run and update every time you run the report.

You're correct, make a link table with its own primary key, and two fields, each data table's record IDs. To automatically update the link table, create a query with the data fields from each data table and the ID fields from the link table. Then create a form and include all fields from the...

Well did you look at the example db I gave you? It should have the exact structure you're looking for.

Had an inspiration, whipped this up. Tell me if it's useful. Still not great for me since I've gotta make a format where I can efficiently input dozens of sub-data sheets like that.

This problem sounds a lot like what I'm trying to figure out at the moment, except without all the restrictions. I need to import multiple listed values from an external source into a single list field. I think I'll keep an eye on this thread; I'd help you but I have to go. I'll be looking later...

Multiple professors linked to multiple courses, and vice versa, is not one-to-many; it is many-to-many. Create a third table, include an autonumber PK of "link ID", create a field for professor ID, and a field for course ID. Make sure the data types are the same, then link the prof ID to...

replace the Balance column in your tables with the calculated, updated balance field in the query from the sum query.

I think he's trying to make it update like that. Create a seperate query to sum the credit/debit balance and report the account ID from Transactions. Then create a new query and duplicate your Accounts table in it by including all fields, include the sum query and link them. You should only...

Now I've got your attention - I know it's "editable," not edible ;) I have a survey set, with questions in the following form. I want to squeeze the entire question into a single multivalue field. This would be easy if it were only Question-Yes/No. I need the number and the text alongside it...