Updating Tables

[Davidyam]

Hi,

Is it possible to update a form which links to two tables with similar column?

For example,
I update type of ride, and it updates two tables with type of ride.

If it is possible, may I know how do I go about doing it.



Thank You very much.

Regards,
Davidyam

[June7]

Why do you need to do this? Describe structure and relationships of the tables. Possibly you need to use a form/subform arrangement. Or your structure is not correct.

[orange]

Further to June7's comment, you only UPDATE record(s) in 1 table at a time.

[Davidyam]

Hi June,

I need to do these because I need the data to be shown in sharepoint. As sharepoint does not allow two columns with attachment, I need to make another table with another column just for these attachment, however, both attachment column are in the same form.

Example
My form has two attachment box, one for manuals and one for service bulletins. I have placed the table into sharepoint but it only allows one attachment column. I need my form, when updating Data, example description, to be able update both tables just so that my supervisors are able to view it when they access to sharepoint.

Is it possible?

Thank You very much

Regards,
David Yam

[June7]

Oh, I have never used Sharepoint.

So you have two attachment fields, each in a separate table? Both tables have another field, each of which has the same data? You need to update this field for existing record or you are creating new record? How will you know which record of each table to update? There is a field in both tables that is a common unique ID?

I suppose SQL insert or update actions would work, I just don't understand your data structure or Sharepoint enough to advise how. Think I have seen one project set up for Sharepoint. Don't you have to use macros, no VBA? I use only VBA.