An ASP question, a bit complicated, okay I ll add points

The common denominator of table c table d table e is the clerk number. Or it is the name of the salesman you said, it is also an unchanged value, and it cannot be repeated, and the same name is not allowed to create a new salesman.

3. Tables are associated with loops. According to the salesman number, the association is carried out and the data is cycled. .

3. Compare the dates of the table and call up the date of the latest operationto sort.

Typography Date Comparison Sort by date, using JS and ASP regex.

It's a bit difficult, just like the year and date sorting you listed above, I suggest you put the date in a table, now there are dates in 3 tables, if you sort directly in a table. In fact, simply sorting by date is an erroneous irregular sorting method, because if multiple operators send messages on the same day, how do you deal with the sorting? At this time, you need to use other field values to compare and sort the results of the date sorting again, which I feel is difficult to implement with acc, sql2000 can be achieved in one sentence.

Because SQL 2000 is a relational database, it is complex but powerful and meets many user needs.

In fact, having said that, your current situation is that you don't want to change the table database table structure, but want to use ** to repair the perfection, this is really a kind of picking, can be simplified, I prefer to do complex. But you need 5 strong ** design ability, there is no impossibility, only you give up and do not give up.

To store data in multiple tables, you need to have a relationship between the tables.

For example, use the ID in the salesman's table as a flag.

Create a field in the business volume table with the same value as the id field in the salesman table.

In this way, it is possible to connect.

When using ASP, call out the salesman's name and ID number first.

Open another table and look for the records associated with this ID.

If you want to show them all, it's nothing more than a loop.

But I still recommend that you combine the other tables into one table.

Dates should not be associated in the table, they should only be used as a condition record.

For example, your salesman has his own ID, which is his only identifier (because there will be duplicate names).

In the datasheet, everything needs to be associated with this ID in order to work.

ACC database idea to give you the answer: if the answer is not what you want, please add the question description and answer it as soon as possible.

ACC data creation yewu table Design Fields ID Primary Key Name field xink field genk field chengk field Date Creation time field Attribute Date Select acc directly new() function All set to text attributes. You can also set numbers, in which case you can only enter numbers, and if you set text, you can enter both numbers and strings.

Then the background uses the form to pass values to add content to yewu This table, and finally read all the pages in the background, use the do while loop to add if with .

table_c,table_d,table_e。

For example, if there is a field ID in Table C, then Table D needs to create a field that is specifically associated with a field connected to Table C, such as CID

In this case, a field should be created for Table E to associate with a field connected to Table C table ID, such as CID

In this way, when calling data, you can batch and call the CID data in Table D table and Table E table according to Tom's ID.

Note: Of course, you must write a piece of data to three tables at the same time, and when you write table c, you need to get the data in the id field, and write it to the cid field of the other two tables.

It's a bit complicated to say this, but it's no problem to do so, and I won't explain it when it comes to **.

This can be done with **, as long as the table is connected by fields and has a certain logical ability, it is no problem, that is, the combination of some SQL statements.