I have 2 tables in a base one is news and the other is region and they are linked by a column called country. Is there a way when a new record is inserted into news that the record is updated based on a value in the row?
For example if a new record has Express Newspaper in a column called source I want the country column within that row to automatically update based on corresponding information found in the region table.
Can this be done?
In general, yes, you can use a lookup field to populate any information from the other ‘side’ of a linked record. Your news record would, of course, have to be linked to the region record to do this.
What it sounds like, though, is that you may need a Sources table which would sit in between Regions and News - so that when you select a source it would effectively be selecting country as well.
If this is the case then to get information from Region to News you would first have lookup fields on the Sources table - and then lookup these in turn from News.
I hope this makes sense?
No - if you don’t need a Sources table then the News table must be linked to the Regions table - in this way you can pick up information from the region table - for example:
Here we’re holding the Flag and Language against a country - and …
Here the two fields are being picked up in the news table based on the lined field Region.
Region is a link to another table
Flag and Language are Lookup fields based on that link
Care to share a bit on how you solved this? i’m dealing with similar situation need a row from Table A to be updated with some values of Table B when those fields are updated or some values are added to them. Imagine customer signature, etc … I’d like to have the customer signature in Table A for the associated order. Thanks so much